asked on
MS Access - Unable to View Tables, Queries, etc.
Hello,
I'm trying to view the tables, queries, etc. of a database. It looks like the database creator hid these from the end users because when I open the database all I can see is a Form (the design tab, etc. are not visible). Is there anyway I can view these? The creator is out on leave so it will be awhile before I can ask him. And, out of curiosity, how is the creator able to see these? The database does not ask for logon credentials when you open it. Is this done through linking to another database or something?
I'm trying to view the tables, queries, etc. of a database. It looks like the database creator hid these from the end users because when I open the database all I can see is a Form (the design tab, etc. are not visible). Is there anyway I can view these? The creator is out on leave so it will be awhile before I can ask him. And, out of curiosity, how is the creator able to see these? The database does not ask for logon credentials when you open it. Is this done through linking to another database or something?
Microsoft Access
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Hi ...
Note: In the Nav Pane, if you right click over a Table that is now visible ... and select Table Properties, you can uncheck the Hidden property.
And you can tell if the Hidden Property is set because that Table name will be grayed out of sorts.
Note: In the Nav Pane, if you right click over a Table that is now visible ... and select Table Properties, you can uncheck the Hidden property.
And you can tell if the Hidden Property is set because that Table name will be grayed out of sorts.
If the developer distributes as an .accdr, you can try renaming to .accdb and see if the above instructions work.