Multiple paswords of Access database

Posted on 2012-09-04
Last Modified: 2012-09-13
I have a database in which the data is maintained by the secretary.  She wants a way to require any user to log in using a password.
The idea is that she will have full access to the database, and others (the committee) will have access that allows them to print a list or send an email, but not let them change any data.
We aren't looking for earth-shattering security, and the committee are not likely to try hacking in.
I understand creating a password using Database Tools>Encrypt with Password, but don't know if that will allow me to make two
Question by:msmerry
    LVL 48

    Accepted Solution

    LVL 56

    Assisted Solution

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    Microsoft removed user level security from the product starting with A2007 and replaced it with nothing else.

    For this type of setup, you'll need to build-in your own security system.  

    There's nothing within Access that will help you do this.

    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    If you don't want to invent this yourself, you might consider something like this:

    This is Light Application Security, and allows you to define different users and groups, and define what actions they can take.

    Note also that this will not provide you any form of true data security. Users would still be able to link to the database with another program (Access, Excel, etc) and view all data in the tables. If you want to prevent that, you've need to encrypt the db with a password, and then build a "launcher" app that would supply the password (so the users won't know the password).

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now