Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

An Access database is getting to much data through forms so new copies get made. To make the old data available for searches the tables should be linked. The problem is that the menu group "EXTERNAL DATA" is not available. The reason for this seems to be that the file is in forms mode. As the many forms and interface elements in this file are available.

Another Access file does have all menu groups available, and it has the screen "All tables" open, so there seems to be a "table" mode.

So how to get "table" mode working or otherwise link Access tables? The file does have database entries, as it's size is 1,08 GB.

share|improve this question
up vote 0 down vote accepted

It turns out this access file opens in a sort of protected mode at default. To open it in full mode hold Shift and open it. So theres no password or clicking buttons (like administrator mode) just opening the file while holding Shift.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .