Link to home
Start Free TrialLog in
Avatar of eemmpph
eemmpph

asked on

How can I "secure" my Access 2002 database?

I have a Microsoft Access 2002 database.

I would like to set up "Security" where:

User #1:  Can change the data and design of the database (i.e., the Administrator).

User #2:  Can only update data, view and print reports.

User #3:  Cannot update data, but can "View" the data from the "Forms" screen and "Print" reports.

I use Visual Basic to program command buttons on the Form, which enables users to "find" client records, and "Print" client records.

Thanks for your help!
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of eemmpph
eemmpph

ASKER

Thank you Pat for your solution.  It would solve the problem with security.

In the next few weeks, I plan on replacing the Access 2002 database with a 2013 Access database.
You're welcome.