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

MS Access - Unable to View Tables, Queries, etc.

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?
  • 2
1 Solution
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Check this setting
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.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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