• Status: Solved
  • Priority: High
  • Security: Private
  • Views: 46
  • Last Modified:

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!
  • 2
1 Solution
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.
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.
You're welcome.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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