Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Location
    new providence, New Jersey, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    AllowBypassKey Prop (Access 97 SR2)

    I hope I'm not missing something obvious and asking an extremely dumb question, but if I choose to run VB code to set the AllowBypassKey property for a database to False, where the heck am I going to run the code from where it won't be bypassed if the user SHIFTs to bypass startup options?

    Thanks in advance to anyone who can clear this up for me!

  2. #2
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AllowBypassKey Prop (Access 97 SR2)

    You do not need to run the code but one time. It creates the property and sets it. It will remain set until code is executed to change it. I, myself choose not to "clutter" a database" with the necessary code to do this. I use a remote (external) database that will set and unset the property with anyout code place in the app effected. Using this approach also keeps you from having to place a "hidden backdoor" to allow you access should you need to change something.

    If you would like a copy of the db I built for doing this, email me and I will send you a copy.

    This db will set the ShiftKey property for any Access database version .... Access 97 and up.


    rdhicks@mindspring.com

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

  3. #3
    New Lounger
    Join Date
    Apr 2001
    Location
    new providence, New Jersey, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AllowBypassKey Prop (Access 97 SR2)

    I emailed Ricky to ask him for his database and would like to thank him here for a quick response to what was (I'm afraid) a pretty dumb question.

    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

  4. #4
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AllowBypassKey Prop (Access 97 SR2)

    You are welcome ..... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    In my opinion, there are no dumb questions ..... especially if you need help.

    Remember that all questions are easy ..... if you know the answer.

    But what can be very simple to one person, can be a major obstical to others.

    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •