tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

MS Access: View hidden tables in Access 2007

See solution in other versions of Access:

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.

Microsoft Access

When the Navigation Options window appears, check the option called "Show Hidden Objects". Then click on the OK button.

Microsoft Access

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

Microsoft Access

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

Microsoft Access

Learn how to hide tables as hidden objects.