+ Reply to Thread
Results 1 to 8 of 8

Make Access database file password protected or read-only

  1. #1
    Registered User
    Join Date
    10-27-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    39

    Make Access database file password protected or read-only

    Hi,

    I would like to password protect a database file but allow users who don't know the password to open the file as read-only. It seems that I can only get it to either be read-only to everyone or you cannot view the file if you don't know the password. Looking online it seems there are some ways to do it by manipulating the network or security of the work group, etc.

    I am wondering if there is any simpler way to do this that doesn't require any IT level manipulation.

    Thank you.

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Make Access database file password protected or read-only

    Simple alternative would be to have 2 copies of the database
    - UserCopy = allow edit
    - ViewCopy = read only

    and then give each user permission to either UserCopy or ViewCopy
    Last edited by kev_; 11-17-2017 at 12:49 PM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    10-27-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    39

    Re: Make Access database file password protected or read-only

    Thanks for the suggestion.

    But then wouldn't I have to update both files separately every time I want to make an edit?

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Make Access database file password protected or read-only

    Yes
    - the ViewCopy requires updating periodically
    - how frequently depends on the requirements of ReadOnly users

  5. #5
    Registered User
    Join Date
    10-27-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    39

    Re: Make Access database file password protected or read-only

    Is there no other way to do it with just the 1 file? I would rather not have to update both files individual each time I make an edit as I will likely be making edits frequently.

  6. #6
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Make Access database file password protected or read-only

    You can do it by setting Permission level on the folder and the file itself. No need to set password.

    1. All user should have Create files / write data permission on the folder. This is required as Access will create lock file for the first person to open database for the session.

    2. Give only the users that you want editing rights, both read & write permission on the file (.accdb/.mdb). For other users, give only read permission on the file.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  7. #7
    Registered User
    Join Date
    10-27-2017
    Location
    New York City
    MS-Off Ver
    2016
    Posts
    39

    Re: Make Access database file password protected or read-only

    Thank you CK76, can you explain the steps that I would do that?

  8. #8
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Make Access database file password protected or read-only

    You'll probably need IT's help if you don't have admin rights on the folder.

    First right click on the network folder where the file is stored.
    Go to Security tab. You should see Edit option. Assign Read & Write to all.
    Then right click on the file assign appropriate permission to each (or see if your IT can create permission group for you and assign it via Active Directory).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Access database linked with password protected SQL server
    By Jenkins27 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2016, 08:44 AM
  2. [SOLVED] Creating a password protected, Read Only file
    By demetrius323 in forum Excel General
    Replies: 3
    Last Post: 02-10-2015, 02:15 AM
  3. Open a password protected Access 2010 Database from a Excel
    By Cherry.P in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2012, 09:09 AM
  4. How to connect vb with password protected access file
    By Reema in forum Access Tables & Databases
    Replies: 2
    Last Post: 06-02-2009, 02:40 AM
  5. Reading Access Database that is password protected
    By SQUASH JUNKIE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2008, 06:50 AM
  6. can't open password protected file as read-only
    By ClemM in forum Excel General
    Replies: 0
    Last Post: 01-10-2006, 12:40 PM
  7. [SOLVED] How do I make a file read only unless a password is supplied?
    By Tim in forum Excel General
    Replies: 2
    Last Post: 01-12-2005, 07:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1