Startup options with shift key in Access 2002

Posted on 2006-04-12
Last Modified: 2008-01-09
Hi, I wrote an access app a few years ago and have forgotten how I put the Shift Key option on startup in Access.  That is, the app runs and opens a form, but the user cannot modify.  I know this is pretty stupid, but How do I restore the Access app so the startup doesn't need the shift key to allow the user to mess with the tables?  I don't see any macros that are used in the load form event.  
Question by:DLJ
    LVL 84
    This link will show you how to do it:

    Remember, however, that you'll have to re-enable the shiftkey, then close and reopen the app. Specifically, you'd need to copy both code modules you find at the link, then run it like this from the Immediate window:

    ?ChangePropertyDDL("AllowByPassKey", dbBoolean, True)

    You can get to the Immediate window by pressing Ctrl + G
    LVL 58

    Accepted Solution

    > so the startup doesn't need the shift key

    I think it's more simple:
    * open once with Shift
    * choose "Tools / Startup..."
    * reenable all needed checkboxes, perhaps remove the form
    * close
    * choose "Tools / Options"
    * enable viewing of hidden objects
    * close and check if you have an AutoExec macro
    * if you do, rename it

    That would be all, I think
    Good luck!

    Author Comment

    This worked fine.  THanks for the quick response.
    LVL 58

    Expert Comment

    Glad I could help. Good luck!

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    754 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

    19 Experts available now in Live!

    Get 1:1 Help Now