Cannot open MDB file in design view

Posted on 2006-06-06
Medium Priority
Last Modified: 2013-12-05
Hello all,

I have an mdb file that is used by Quality Control employee's to update the data. They need to make changes to the access database. When I go to open the mdb file as they do I only have the ability to enter the data. .Various buttons and menu options are removed, such as the View and Tools menu. Also when I open the mdb I am prompted with a security warning message to open or cancel opening the file. I am suspecting that some type of a Macro is being kicked off at the start of the application.

I need to be able to open the mdb file in design mode and have the ability to access the tables with populated data. Can anyone provide suggestions as to how I can get around this. Thanks.

Question by:kwoznica
  • 2
LVL 65

Expert Comment

ID: 16843044
If this is not a MDE, but an MDB

Try opening the database (hoping they havent coded the bypass security)

but pressing the SHIFT key then double clicking on the DB to open (not shortcut, but actual file)

u may need to do this a number of times

If bypass security has not been disabled, it will eventually let u into the database

when u get  in, go to Tools/Startup and enable everything

look for a macro called AutoExec and rename that

LVL 77

Accepted Solution

peter57r earned 2000 total points
ID: 16843046
Hi kwoznica,

When you get the security message to open or cancel, choose Open but hold the Shift key down as you do so.


Author Comment

ID: 16844050
Thanks Pete, that worked. How does this get set in the mdb file in case I need to set this option in another database? Thanks.
LVL 77

Expert Comment

ID: 16846623
All the options are in Tools>Startup.

Holding the Shift key by passes these settings.


Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question