Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

access 2007 managing user roles

Posted on 2012-09-14
3
Medium Priority
?
520 Views
Last Modified: 2012-09-18
Hi, i have an access database located on a network that is accessed by several people.  Is there a way to create and assign user roles, password (user selected passwords) and manage abilities within the system based on these user roles?  If not natively available in access, is there a "plug-in" or add-on that I can use.  Perhaps using Acccess as a front end to somethign else?  Please give any ideas you may have.  THank you!
0
Comment
Question by:LadyHagood
  • 2
3 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 38399069
2007 doesn't have any of those mechanisms, so you'd have to build it yourself, or use something like this:

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

Light Application Security can be added to your database, and you can then define users, groups, roles, etc. It's not air-tight security by any means, and is more of a navigational aid than anything else.

If you'd like to build it yourself, let us know and we can help. In general, you'd add tables for Users, Groups, UserGroups, Objects, and GroupObjects.

Users
=============
UserID
UserName
Password
etc

Groups
==============
GroupID
GroupName
etc

UserGroups
================
UserGroupID
UserID
GroupID

Objects
===========
ObjectID
ObjectName
etc etc

GroupObjects
===============
GroupObjectID
GroupID
ObjectID
AllowOpen
AllowEdit
AllowAdd
AllowDelete
etc etc

So you would store the Users, Groups and Objects, then add Users to Groups (UserGroups table), and then assign Permissions to the UserGroup (GroupObjects table). When the user wants to open an Object, you would query the GroupObjects table to determine if they have that permission, for example.
0
 

Author Comment

by:LadyHagood
ID: 38408001
Thanks using the diy method once the db is split how easy is it for an experienced user to break or bypass
0
 
LVL 85
ID: 38411795
It's quite simple - the user can easily open the backend tables and see the Users, Groups, etc etc, or just get directly to the tables.

You can avoid some of this by using a "launcher" app. This is where you build the database and implement the Database Password (but don't reveal the password to your users). You then build a "launcher" app that does nothing more than open your database, using the correct password (which is embedded in your compiled code). So the user opens the "launcher", enters their username/pass, and you then validate that login, and open the real database using the secret password.

If you need true data security, you'd need to move to a more robust database engine (like SQL server), and deploy a compiled application (like a .mde/.accde file, or a .NET application).
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

810 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