Create AllowByPassKey Property in ACCESS 2003

Posted on 2012-09-20
Last Modified: 2012-09-20
I have procedures that work nicely in several databases that disable the AllowByPassKEy property.  But every now and then I get an error when I put it in a new database that the AllowByPassKeyproerty does not exist.  I know that it can be created, and I have done this, but I cannot find the code.  So, how do I actually first create the property in VBA in ACCESS 2003?

Question by:ssmith94015
    LVL 75

    Accepted Solution

    The link below contains an MDB which allows you to 'set' and 'reset' the Shift Key Bypass from a REMOTE mdb.  
    It's very cool. Scroll down the page to 'By Pass Shift Key Code'
    And it works in A2010 also.


    Author Closing Comment

    Thank you!  I have databases covering 2003, 2007 and 2010 so anything I can port across simply makes things easier.

    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    It's a cool little utility ... thanks to Albert.


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    The canonical version of this article is on my web site here: A companion presentation is available here:
    This collection of functions covers all the normal rounding methods of just about any numeric value.
    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.
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

    755 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

    16 Experts available now in Live!

    Get 1:1 Help Now