User level security - help needed

  • Thread starter Thread starter Astrid
  • Start date Start date
A

Astrid

I'm using access 2003 and am really struggling with creating user level
security.

The database in question needs 3 levels of access;
1. General User - can open and use specific forms (3 in total) to run
queries and filter data, but only have read only access
2. Managers - can fully edit information (apart from delete records), and
only open and use specific forms (about 5)
3. Administrators - Full access to all objects

I have tried to create these levels by doing the following;
- GENERAL USER - Use the 'Read-only' group, and create one generic
logon/password as there are approx 150+ staff members who will need access.
However, this won't allow any forms to be opened/viewed at all. How can I
change this for specific forms?

- MANAGERS - using the 'Full Data Users' group so data can be edited, but I
want to remove the permission for deleting records so they can update, edit
and create new data, but I can't seem to get this right, and again am having
trouble assigning access to specific forms. I will also create one
logon/password as currently approx 35+ staff will need this access level

- ADMINISTRATION - not problem here

Is there anyway I can create the user levels to be as specific as I have
mentioned? I have tried using the Wizard, and read the help/how to sections
and am really confused now.

Any help will be greatly received and appreciated,

Astrid
 
Astrid said:
I have tried to create these levels by doing the following;
- GENERAL USER - Use the 'Read-only' group, and create one generic
logon/password as there are approx 150+ staff members who will need
access.
Click to expand...

Sounds good.
However, this won't allow any forms to be opened/viewed at all. How can I
change this for specific forms?
Click to expand...

Not sure I understand. If you want this group to open certain forms then
just grant it "open/run" permissions to those forms.
- MANAGERS - using the 'Full Data Users' group so data can be edited, but
I
want to remove the permission for deleting records so they can update,
edit
and create new data, but I can't seem to get this right, and again am
having
trouble assigning access to specific forms. I will also create one
logon/password as currently approx 35+ staff will need this access level
Click to expand...

Again I don't understand why you have a problem assigning permissions for a
form but you can set the "allow deletes" property to false.
- ADMINISTRATION - not problem here

Is there anyway I can create the user levels to be as specific as I have
mentioned?
Click to expand...

I don't see why not.
I have tried using the Wizard, and read the help/how to sections
and am really confused now.

Any help will be greatly received and appreciated,
Click to expand...

Don't use the wizard, it does things behind the scenes which won't help you
understand ULS. Try working through the example on my web site and also
read the FAQ from MS (link also on my web site).

Keith.
www.keithwilby.co.uk
 
Back
Top