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!
eemmpphAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
Access 2002 still has User Level Security (ULS) which allows you do do this.  However, the feature has been deprecated for over 10 years so I wouldn't recommend learning it now.

First you have to understand that Access is never truly secure so people typically implement security mostly to prevent accidents rather than to actually protect the database.

There is a lot that has been written on this topic and I'm not going to try to reproduce it here.  As an overview though, you'll need tables and forms to manage logons and define what permissions a user can have.  Try to generalize though. You don't want to have to maintain a matrix of  users to objects.  It rapidly becomes unwieldy.  

Take a look at Lassie security at http://www.peterssoftware.com/las.htm  If you buy the code, you'll save yourself a lot of work and a couple hundred dollars is a pretty small price to pay for it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
eemmpphAuthor Commented:
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.
0
PatHartmanCommented:
You're welcome.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.