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?
Wonderwall99Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Check this setting
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PatHartmanCommented:
If the developer has not disabled the shift-bypass key, you can open the database in design view by holding the shift key while double clicking on the database.  This prevents the startup code from running so the menus should be active and the navigation pane should be visible.  Then to "run" the app, you would find the startup form and run it.  Then you will be able to run the app but still switch objects into design view.   However, if the developer distributes the app as an .accde, then you cannot make design changes and you will not be able to go into design view on any object that has a code module.

If the developer distributes as an .accdr, you can try renaming to .accdb and see if the above instructions work.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.