All Access-objects hidden

petertenthije

Board Regular
Joined
Sep 25, 2012
Messages
176
In one of my databases I can't see any objects anymore in the navigation pane.

I tried changing the navigations options to include all hidden objects, system objects etc. Still nothing.
The VBA editor shows the forms and modules, but the properties are hidden as well. So I can't unhide from VBA either.

The database does work as intended. It opens up on a main screen, with several subscreens that can be clicked through from the landing page. There is no code in the main screen that would hide objects.

This database does not have a password, so it's not a password-protection setting either.

What could it be?
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,327
Try compact and repair if you haven't :)
What is the format / extension of the database file? Is it compiled or run-time or simply ACCDB? Can you edit VBA code?

Have you tried clicking on the top tiltle bar of the navigation pane and selecting "object type" and "show all acces objects" on the popu menu?

Or go into the database optons and turn on show hidden objects. If it is on already turn it off and say okay until back to normal access windows and then go back and turn on show hidden objects. You should now see the objects but they will be greyed out. Right click on that object type title bar and select unhide.

Last option is you create a new database and import everything from the old one into the new one. This should do it 100% if it is not an Office issue.
 

petertenthije

Board Regular
Joined
Sep 25, 2012
Messages
176
Try compact and repair if you haven't :)
What is the format / extension of the database file? Is it compiled or run-time or simply ACCDB? Can you edit VBA code?

Have you tried clicking on the top tiltle bar of the navigation pane and selecting "object type" and "show all acces objects" on the popu menu?

Or go into the database optons and turn on show hidden objects. If it is on already turn it off and say okay until back to normal access windows and then go back and turn on show hidden objects. You should now see the objects but they will be greyed out. Right click on that object type title bar and select unhide.

Last option is you create a new database and import everything from the old one into the new one. This should do it 100% if it is not an Office issue.
Simple ACCDB.
I can edit VBA.
I did try “show all acces objects”.
I did try “show hidden objects”, several times.
And last but not list, I did try compact & repair.

How can I import items from another database, when I can't see the items?
 

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,327
Create a new db file. Go to New Data source>From Database> Access >check Import tables, queries .... > Browse ... > select your corrupt db > OK.
Hopefully you will get a window full of database objects > select them all> Options ... > check the ones you need > and import.
Hope this works.
The other way is for import to be done by VBA - since the db is working then the objects are all there so they can be found. Hopefully the necessary system table is not too corrupted.

have you created any custom Navigation pane groups?
 

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,327
BTW just thought of something to try first:
In Nav Pane select Category Object Type, the Show All access Objects.
Right click navPane title bar > Navigation options ... > Under categories select Object type> then on the right under Groups ALL MUST BE CHECKED.
Check the same by selectring all categories in the list on the right. > OK
 

petertenthije

Board Regular
Joined
Sep 25, 2012
Messages
176
I will try to create a new db tomorrow when l am back in the office.

The other two suggestions you made I already tried as well. :)
 

JonXL

Active Member
Joined
Feb 5, 2018
Messages
302
Office Version
365, 2016
Platform
Windows

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,327
I am almost sure, like 99.999 %, that somehow the db objects are filtered out not to show in the nav pane. I can easily replicate this behaviour on my machine. And this behaviour is at file level.
So if you can't really figure out the filtering, a simple import in another db will sort it for sure. Then you will just have to adjust the start up form, db properties, ribbon etc. (if any)

Do not expect to see any properties for db objects in VBE - maybe only names for modules. All object properties are set in the object designers.
 

petertenthije

Board Regular
Joined
Sep 25, 2012
Messages
176
The decompile did not work either.

I made a copy of the database as suggested by bobsan42, and that did the trick.

Thanks everyone for your help.
 

Forum statistics

Threads
1,089,220
Messages
5,406,925
Members
403,113
Latest member
ms_excel_recal_or_die

This Week's Hot Topics

Top