• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 430
  • Last Modified:

Multiple paswords of Access database

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
3 Solutions
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now