MS Access 2007: View system tables
This MSAccess tutorial explains how to view all of the system tables in the navigation pane in Access 2007 (with screenshots and step-by-step instructions).
See solution in other versions of Access:
Question: In Microsoft Access 2007, how can I view system tables in the Navigation Pane?
Answer:Right-click on the top of the Navigation Pane where it says "All Tables". Select "Navigation Options" from the popup menu.
When the Navigation Options window appears, check the option called "Show System Objects". Then click on the OK button.
Now, you should be able to see all system objects in the Navigation Pane including the Orders table that we renamed to USysOrders in the hide your tables as system objects example.
This MSAccess tutorial explains how to hide tables as system objects.
Advertisements