Home Privacy Policy Feedback Link to us Site Map

MS Access: View hidden tables in Access 2007

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

Question:  I've created an Access 2007 database and there are hidden tables in the database. How can I view these hidden 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 Hidden Objects". Then click on the OK button.


The hidden objects should now appear greyed in the Navigation Pane. In this example, we can now see the hidden table called Orders.


You can then right-click on the Orders table and select "Unhide in this Group" to make the table always visible (not hidden).

To learn how to hide objects, click here.