Home » Questions » Computers [ Ask a new question ]

Why can't I open my Access application in design mode?

Why can't I open my Access application in design mode?

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.

Asked by: Guest | Views: 60
Total answers/comments: 1
Guest [Entry]

"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"