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.
ASKER
When I hold down the shift key, the objects still don't appear and the default form doesn't open either.
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
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
"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
That would be expected, since any start up stuff is being bypassed.
Did this just start happening ?
mx
ASKER
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.
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.
ASKER
But I can't see the new query in the Navigation Pane.
Make sure you (or someone else) did not "Hide" the objects.
Go into the Access Options:
Current Database-->Navigation-->Na
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
Go into the Access Options:
Current Database-->Navigation-->Na
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
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.
mx