5

I have been given an Access 2007 application (mainly VB code) that I need to modify. It has been locked down for production, so the toolbars and so forth are not visible. However, it is a .mdb file, not .mde, so in theory it should be possible to get into design mode by holding Shift while opening it.

But that method has only worked a total of three times out of the (probably) 60 or 70 times I've tried. I realize now that I should have enabled the toolbars while I had it open, but unfortunately hindsight doesn't get me anywhere now. Does anyone know what might be causing the problem? Is it my own fault, or the application's, or Access's?

music2myear
  • 49,799
mmyers
  • 463

4 Answers4

7

F11 may open the design view inside Access, depending on security settings. Give that a bash.

1

If you have not changed the code, and shift has worked for you before, it should work again. It is important to keep the shift key held down until the application has fully opened.

Remou
  • 298
1

There is this special 'AllowBypassKey' Property that can be turned on/off on a mdb file. When on, pressing the 'shift' key allows you to enter design vue when launching the file. Once it has been turned off, you can stil manipulate the value by opening a blank access database and write some vba code that will open the initial database, change the property, and close it.

Another solution would be to create an empty database and make a global import of everything available in the first file. On this new database, 'AllowBypassKey' will be by default set to True

Philippe Grondier
  • 113
0

Sticky Keys are enabled by pressing the Shift key five times in a row on Windows XP or newer. This can be disabled by going to Control Panel. I don't know if this could cause a conflict with it or not.

Gareth
  • 19,080