Access: View system tables in Access 2007

Also learn how to view system tables in Access 2003/XP/2000/97.

Question:  In 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.

To learn how to hide your tables as system objects, click here.