Access 2010 objects missing

All of the objects in the Navigation Pane have disappeared. I tried compacting and repairing the database, but this did not fix the problem. I also tried unhiding the objects in the Navigation Pane, but this didn't work either. The database seems to be working other than the fact that I can't see any of the objects.
PerfishentAsked:
Who is Participating?
 
PerfishentConnect With a Mentor Author Commented:
I tried showing the hidden objects before.

Just now, I tried importing all of the database objects into a new database. I can see all of the objects in the new database. This may be the best solution.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
If you hold down the Shift Key while opening the db, does this change it ?

mx
0
 
PerfishentAuthor Commented:
When I hold down the shift key, the objects still don't appear and the default form doesn't open either.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Dale FyeCommented:
Is the navigation pane even visible?

If not, open up the VBA code window (Ctrl-G), and type the following in the immediate window, then press enter.

DoCmd.SelectObject acTable, , True
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"r and the default form doesn't open either. "
That would be expected, since any start up stuff is being bypassed.

Did this just start happening ?

mx
0
 
PerfishentAuthor Commented:
Yes, the navigation pane is visible. I tried the code you suggested in the immediate window using the name of a table I know should be there. When I ran the code, I got an error saying the object could not be found.

However, if I create a new query , I can see the "missing" table in the Show Table screen. And I can use use the missing table in the query.
0
 
PerfishentAuthor Commented:
But I can't see the new query in the Navigation Pane.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Make sure you (or someone else) did not "Hide" the objects.

Go into the Access Options:
Current Database-->Navigation-->Navigation Options
Turn *on* the option for: Show Hidden Objects

If the objects display after that, then you can right-click them and select Properties, then turn off the "Hidden" setting.

JeffCoachman
0
 
als315Commented:
May be shortest way - import all objects to new empty DB? If you see objects in query designer, you should see them in import master.
0
 
PerfishentAuthor Commented:
The database was probably corrupt as evidenced by the fact that compacting and repairing did not fix it. And unhiding hidden objects also did not work. The only solution that worked was to import the database objects into a new database.
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.