How to set up security levels in MS Access

I would like to set up different security levels, does someone have a good link on how to do this?
LillyCAsked:
Who is Participating?
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.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
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
LillyCAuthor Commented:
Thanks Scott - I'm using 2010/2013, so I'll go down your suggested route.
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
Microsoft Access

From novice to tech pro — start learning today.