User-Level Security

[deville75]

Hi, I need to add a security feature to my database. Basically I want different users to access the database with different permissions. I want a "basic user" to be only able to access the the forms with their respective default settings. I want an "admin" to obviously be able to access all the content and edit the design. I know I can do this with User-Level Security somehow, but i've tried it and it isn't working like I want it to. DOes anyone know or have any experience with this security feature.

 

[rainman89]

Add a usersecurity level to your users table and set lvl1=admin lvl2= user etc.. then on your switchboard..( if u are using one) set the appropriate options visible if userlvl=1 and not visible for 2

or use access security features!

 

[MicroE]

Check Out:
http://www.databasedev.co.uk/access_security.html

 

[The_Doc_Man]

Search the forum threads for "Workgroup Security" and "Securing a Database" to find a whole BUNCH of threads on this topic.

 

[deville75]

Check Out:
http://www.databasedev.co.uk/access_security.html

I checked this out and it's cool, but I get this error when I select User-Level Security in my database:

The security wizard cannot be run on a database when you are both logged on as the Admin user and the database has been previously secured. To fix this problem, you may log on as another member of the Admins group or import all objects to a new database.

 

[MicroE]

If you removed the Admin user from the Amins group, then you need to login as a user who is part of the Admins group.

 

[deville75]

Ya I logged in as another user of the Admins group, but when I try to access User-Level Security with this user it lets me, but when I finishe the wizard it gives me this error:

Error 'An unexpected error occured while changing the owner of the database. This problem can occur if you have (1) previously created the database while logged on as one user, (2) secured it previously using the Security Wizard in any version of Access, and then (3) logged on as a different user to run the Security Wizard this time.' The wizard can't complete successfully.

 

[rainman89]

make sure you are logged on as the owner of the db... admin is probably default.

 

[deville75]

I went to "Change Owner" dialog and it says the owner of the database is <Unknown>. And the 'Change Owner' button is grayed out. So i can't even change it, how do i fix this?

 

[MicroE]

Try making the Admin user part of the Admins group. Then when you are finished with the wizard you can switch back the account (make sure at least 1 user is in the Admins group).

 

[Joe8915]

try this

Create a desktop shortcut with the following in the target:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

"path to msaccess.exe" is the path to the 2007 version of msaccess.exe
"path to mdb" is the path to the secured mdb
"path to mdw" is the path to the secure mdw on the network