Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010

    Unanswered: Prohibiting access to parts of a database?


    I am new to Access (I have 2010). I am currently sharing my database by placing the database file into a Dropbox folder (Dropbox createis a folder that is synced to multiple computers)

    I would like to prohibit access to most of the tables/queries/forms in the database.

    -Password protection would be a good option.

    -Another solution is to setup my database to synchronize information from a smaller database without all the sensitive data (this is the one the employees would use)

    Is there any easy way to do this?

  2. #2
    Join Date
    Oct 2010
    Have you tried creating an .accde file and placing that file in the dropbox rather than the accdb? You can also set a password on the database in the Database Tools tab with the Encrypt with Password button.

Posting Permissions

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