How to set up security levels in MS Access

LillyC
LillyC used Ask the Experts™
on
I would like to set up different security levels, does someone have a good link on how to do this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:
What version of Access? The last version that included User Level Security was Access 2003.

If you're using 2007 or greater you'd have to create your own security system - or rather a "navigation" system, because you really wouldn't have much in the way of security. You can make it as simple or as complex as you want. You could have a single table with all Users, and store the password in that table, along with the permissions they have. You'd then check that table each time the user performs secured actions, like opening a Form or Report.

You could also have multiple tables: Users, Groups, Objects, and Group_Object permissions, for example. You'd add Users, create Groups, add your Users to Groups, add your Objects, and then set permissions for each Group.

Or you could use LASsie from Peter's Software:

http://www.peterssoftware.com/las.htm

Note, however, that none of this has any sort of data security. It's simply "navigational" security, meaning you allow UserA to open FormB, but not FormC. Users can still get to your data. If you want data security, you'd have to move to a more robust database, like SQL Server.
LillyCDatabase Developer

Author

Commented:
Thanks Scott - I'm using 2010/2013, so I'll go down your suggested route.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial