Why have queries gone from navigation pane

[RayFrew]

Yesterday the queries (and tables) were displayed in the navigation pane - today they are not. The users tell me that they did nothing. The database still works so I guess that the queries are "hidden" not deleted. The database options are set to display "hidden" items so they should appear in the navigation pane.
I suspect that this database is having real trouble keeping itself together.
Has anyone any ideas on how to fix the problem and bring back the query references? Many thanks
Ray

 

[Mihail]

What happen if you copy a DB from the users computers and open it in your computer ?

 

[RayFrew]

Hi Mihail

I copied the database onto my laptop which is running Access 2010. The queries and tables are not showing in the navigation pane. When I opened the Immediate window and typed
? CurrentDB.TableDefs.Count I got the error 3167
? CurrentDB.QueryDefs.Count also gave the error 3167
The curious thing is that the database continues to function. Forms are working even though they are driven by the "missing" queries. The forms update the "missing" tables without a problem.
I'm hoping that the tables and queries can be resurrected somehow and that we don't have to go back 2 days and lose data.

Any ideas welcomed.

 

[Mihail]

Unfortunately I have only A2007.
But there are other members on this forum that use 2010 so, my advice is to remove all data from your DB and to post it.
Maybe someone will find a solution.

 

[namliam]

Is your pane perhaps filtered somehow? there are different filtering options that wont show the queries

 

[RayFrew]

It doesn't appear to be a filtering problem. By using VBA to look at the underlying tabledefs and querydefs I'm convinced that Access has lost its way somehow. Those vba queries should have given me a record count of tables and queries - not an error message.

I've just tried a compact and repair on a copy of the database and it didn't fail - which is good. It threw up a few errors but at least the table and query names are now back in the navigation pane.

I think I'll leave it there. Thanks for your help.