No Objects in Navigation Pane

[dmccarville]

I am using Microsoft Access to link to some tables in SQL Server. There are two linked tables (that are in SQL Server), several local tables, and a dozen or so queries.



Yesterday at some point, my navigation pane became blank. There are no objects listed there. I suspect the objects are still in the Access database, because I can author a new query and it can access both the linked and local tables. The database documenter tool works (it provides all the right details for my tables and columns), and the database still has a large file size (~1.8 GB).

I opened up the drop-down in the navigation pane and made sure it was set to "Filter by Group: All Object Categories" so that nothing is being filtered out.

Are there other reasons this might happen?

[June7]

What about setting to Object Type and All Access Objects?

[ssanfu]

Strange...

First, do a "Compact and Repair"


Then try right clicking anywhere in the navigation pane.
Select "Navigation Options".
In the dialog box, there will be two white panes. "Tables and Related Views" will be selected.
Everything in the right pane should be checked.
Click on the next item in the left pane. All items should be checked.
Continue down the list.

On the bottom left, check "Show Hidden Objects".
Click OK.

Hopefully, the objects will be displayed.