asked on

Cannot open MDB file in design view

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.

Keith

rockiroads

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

ASKER CERTIFIED SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kwoznica

ASKER

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.

peter57r

All the options are in Tools>Startup.

Holding the Shift key by passes these settings.

Pete