Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Database Security (XP)

    I have one database that requests the database password when being opened. Others do the right thing and only ask when you try to get into the VBE but this one asks whether you start with or without the shift key. I obviously can't distribute it like this. Anyone got any clues?

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

    Re: Database Security (XP)

    A database can have a VBE password, a database password, and a prompt for username/password. Apparently, a database password has been set on this particular database.
    It is possible to disable Shift as bypass key for a database - see <post:=181,926>post 181,926</post:>.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database Security (XP)

    Thanks for the fast reply. I have a copy of the database before I applied a database password. In the short term I can just disable the shiftkey on startup using the Property Editor written by Jamie Czernik but somebody could still edit this property to gain access. Previously I have applied a database password that was only prompted for when I opened the VBE I thought that it was the database password. this allowed users to edit and create reports and forms but denied acces to code which is what I want.
    Do you know how to set the VBE password?

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

    Re: Database Security (XP)

    To set the VBE password:

    - Activate the Visual Basic Editor (Alt+F11).
    - Select Tools | <projectname> Properties.
    - Activate the Protection tab.
    - Tick the "Lock project for viewing" check box.
    - Enter the password in both password boxes.
    - Click OK.

    The password will become effective the next time you open the database.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database Security (XP)

    that's what I wanted - Thankyou very much.

Posting Permissions

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