creating different levels of permissions for access users and adm.

[Guest]

I am trying to set up a database that will allow the Admin staff to have
greater control over the system than the users. i have set up the users but i
am having trouble in changing the premissions for the different users.
Iam using access 2003

 

[Guest]

Grant the different permissions to two Groups and assign each user to a group
(or to both if appropriate for some users). Don't assign individual users
permissions. Don't call the groups Admins or Users however; those are the
names of the built in default groups. In a secured database all users must
be members of Users, but that group is denied all permissions. The Admins
group has non-revokeable permissions so only the database administrator
should be a member of Admins.

For an overview of Access security see:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

Ken Sheridan
Stafford, England