Cannot open MDB file in design view

Posted on 2006-06-06
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
    LVL 65

    Expert Comment

    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

    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

    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

    All the options are in Tools>Startup.

    Holding the Shift key by passes these settings.


    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now