Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008

    Unanswered: password protection

    I have a database that would like to secure it.

    I would like to have a database file, that could be on 3 computers and that each one is pasword protected. When someone tries to open it it would demand usewrname and password - and user will be able to write new data/entreis.

    Under Tools / Security I tried to setup administrator, user and admin properties and tried to create accounts for users and then setup security for final users.

    Somehow I do not manage to get combination that would work. Either it opens file normaly without any password or it asks for pass, but that says that it cannot read ...


  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Make sure you have a copy of your database backed up before playing around with security!

    Make sure you have a password to the Admin user and you'll be prompted for a username and password when opening.

    Create your user accounts with their passwords.

    Next, you have to change the security settings for each object - making sure you give each user the correct permissions according to how you want it to work.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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