MS Access Security

Posted on 2013-09-12
Medium Priority
Last Modified: 2013-09-13
I have a client who is trying to set up the database in Microsoft Access and they want to have two levels of security - an admin who can make changes and a basic user who has read-only access. I haven't found any straight forward documents that tell how to do this. Someone suggested a command line with the/RO option, but that's not really security. Does anybody know how to create a user level security feature?
Question by:Sven Mogelgaard
LVL 17

Accepted Solution

Kent Dyer earned 1000 total points
ID: 39488093
Microsoft Access does have a tool..  Called WRKGADM but you do have to run this from a common share or re-apply the file to each workstation.


LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 1000 total points
ID: 39488157
It is true that Access used to have User Level Security (ULS) in the older JET (.,MDB) database format. It was dropped in the new ACE (.accdb) format. Most people are migrating away from it since it was very difficult to implement correctly

If you are interest in the old ULS technology then see: Jack MacDonald's How I use Microsoft Access User-Level Security

Whatever method you use you will want to split the database.

To keep it simple, make two front end. One for the admins. And One that is read-only.

Read-only can be handled with windows file permissions on the back end or in the front end by setting the forms to not allow edits, deletes, or additions.

Also see this example of a common way to handle user security with a single front end

Boiler Plate Database

This is a moderately advance database that incorporates a number of functions such as 1) user logon 2) table reattachment 3) user tracking 4) how to control access via the use of modal switchboards and more. FYI: Username = admin; Password = admin.

Author Closing Comment

by:Sven Mogelgaard
ID: 39492019
I will check out the tool. But will likely just create two front ends.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question