• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2461
  • Last Modified:

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.
0
Perfishent
Asked:
Perfishent
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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 CoachmanCommented:
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
 
PerfishentAuthor 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
 
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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now