Thread: Empty Navigation Pane?
08-27-14, 11:48 #1Registered User
- Join Date
- Aug 2014
Unanswered: Empty Navigation Pane?
I am using Microsoft Access 2010 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?
08-27-14, 12:37 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
Things start getting hinky as an Access file starts approaching its size limit, and yours is just below the 2 GB limit. I wonder why it is so large, given your description.
First thing I'd try would be to move everything into a new, blank file.
Second thing I'd try (on a copy of your file...store the original somewhere safe) would be to do a Decompile/Recompile of the file:
Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption
Linq ;0)>Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007