Navigation Pane, missing all objects

After compacting and repairing my database, I noticed that all of my tables, queries and so on were missing from the Navigation pane in Access 2010.  I've tried to reset the Navigation options with no change.  Has anyone experience this before, and if so, can you offer a solution?

Thank you.
Robert CarmanAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
First, make a backup of the DB as it is now.

Then create a new DB and try to import all the objects form the old db.
If no objects are listed, ...then somehow the objects gt hosed...

Then you may want to try decompiling the db:
http://www.fmsinc.com/microsoftaccess/performance/decompile.asp
Then try creating another new db and importing all the objects...
0
 
Robert CarmanAuthor Commented:
Jeffery, thanks for the advice!  I'll give it a try.

Rob Carman
0
 
mbizupCommented:
Just as a sanity check, make sure you don't have anything entered in the 'Search' box on the Navigation Pane that would filter out all objects.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jeffrey CoachmanMIS LiasonCommented:
...and in reading mbizup post, I realized that you could have also accidentally "Hidden" all of the objects...
File-->Options-->Current Database-->Navigation
Make sure it looks like this:
Options

JeffCoachman
0
 
PatHartmanCommented:
I have had this happen in A2013 but the objects were actually there.  Clicking on a few things woke up the nav pane and it then showed everything.

If objects are actually missing, you'll have to get a backup and try the C&R again.
0
 
Robert CarmanAuthor Commented:
Sorry, thought I had already accepted the solution. I appreciate the quick response to my question and the quality of same
0
 
Jeffrey CoachmanMIS LiasonCommented:
glad I could help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.