Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012

    Unanswered: How to protect our access database?

    How can we hide the left pane and make the tables, queries and reports password protected so that user is only able to work with forms? Moreover I want forms to be only used and be protected from being re-designed.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    It depends on the version of Access you use, among other things.

    1. Split the database on the Front-end/Back-end schema.
    2. Password-protect the code.
    3. Compile to an mde (or the equivalent for Access 2007-2010).
    4. Disable several settings (use of the Shift key at startup, etc.)

    Strategies for Securing an Access Database - Office 2000 Resource Kit -
    Steps to Securing an Access Database by Using User-level Security | Database Solutions for Microsoft Access |
    Securing an Access Database
    Securing an Access Database [AVDF Access Article]
    Using MS Access

    Note: As far as data (tables) are concerned, you'll never reach the level of security and data integrity you could have using a "true" server such as MS SQL Server, Oracle, MySQL, etc.
    Have a nice day!

Posting Permissions

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