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.


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.