User level security - help needed

[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

 

[Keith Wilby]

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.

Sounds good.

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

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

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?

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,

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