Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Shift Key bypass (Access 2K/XP)

    Good morning all,

    I have a db that has user level security employed. I type in my user name and password and hold the shift key down before I click ok to bypass the startup screen and view the database window of tables, queries etc. This does not work on this database; used to work, but not any more. I have Full Permissions on this db. Any ideas?? TIA.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Shift Key bypass (Access 2K/XP)

    It is possible to disable the Shift key bypass. If someone else has done this, you'd have to ask this person whether (s)he built in a backdoor.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shift Key bypass (Access 2K/XP)

    Thanks Hans for your reply. I think it will be impossible to find anyone to admit that, but I'll try.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Shift Key bypass (Access 2K/XP)

    Another option would be to import all database objects into a new databae (using the secured .mdw file).

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Shift Key bypass (Access 2K/XP)

    If you can get into the Visual Basic Editor, try this:

    Activate the Immediate window (Ctrl+G)
    Type

    CurrentProject.Properties("AllowBypassKey") = True

    Press Enter.
    If you don't get an error message, you should be able to use Shift the next time you open the database.

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Shift Key bypass (Access 2K/XP)

    Can you get to the Startup Options? From Menu Bar, Tools | Startup.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shift Key bypass (Access 2K/XP)

    I cannot get to the Visual Basic Editor, cannot get to the Tools| Startup options. It looks like someone created custom menus. Screen shot of menu is attached.
    Attached Images Attached Images

Posting Permissions

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