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.

I'm wanting to investigate a problem with a former colleague's Access 2003 database/application. When I fire up the database, a default form opens; when I press F11 to look at the underlying code, the expected dialog opens but I don't have access to all the menus and rt-click functionality is disabled.

There is an autoexec macro, which sets warnings on, runs 3 queries, and opens a form. The form load event doesn't reveal much either.

How can I open this DB such that I can edit it again, that is, so that I have full menus and right click functionality?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

Typically, solution was found immediately after posting!

I tried pressing Shift whilst opening the database, which I was led to believe would prevent autoexec and other settings from kicking in, but it didn't work.

However, having tried again (after disabling the security warning that came up), the Shift trick did work.

Then I clicked on Tools > Startup, and ticked the following options:

  • Allow Full Menus
  • Allow Default Shortcut Menus

... and the next time I opened the DB, the menus were as expected.

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.