Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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