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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome.
ASKER
In the next few weeks, I plan on replacing the Access 2002 database with a 2013 Access database.