How secure is AllowByPassKey=False?

Posted on 2006-04-07
Last Modified: 2008-01-16
Is there any way for a hacker to access the objects of an mdb file for which the AllowByPassKey property has been set to False, or is it as secure as MS claims?
Question by:Milewskp
    LVL 42

    Accepted Solution

    I don't know what MS claims, but it's relatively easy to hack.   Just create a new .mdb file, import all the objects from the "locked" one and you're in.  

    Or you can download the free property editor from

    My feeling is, that anyone who knows enough to shift-start an access app won't be fooled for too long.

    LVL 39

    Assisted Solution

    You can find a demo database with shift bypass functions at:,  ShiftBypassDemo
    LVL 58

    Expert Comment

    I agree, it's about as secure as hiding an object or a file...

    The next step in security is to distribute your database as MDE. Although any user with a full version of Access can still get to the database window quite easily, the objects can not be edited.

    LVL 1

    Author Comment

    Thanks guys. I'll split the points between the first two answers.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    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!

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    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…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    737 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

    23 Experts available now in Live!

    Get 1:1 Help Now