User and Group Permissions

[Rach1978]

Hi again everyone,

I had some excellent help from here last week - for which I'm eternally grateful - but am now stuck on something else which has been bugging me all day.

I'm trying to set permissions on my database. Basically, I need an Admin group who have full read/write access to all forms, queries and reports and a User group who have read-only access to only certain forms.

I've set this up fine on my computer - but when I tested it on other PCs in the office, no permissions were set at all. I presume the settings are therefore saved locally and not in the same place as the main database is saved (on the shared drive).

I realise I need to do something to a "system.mdw" file, but I'm really not sure where to start.

Sorry if I'm not making sense, but I'd really, really appreciate if anyone could help me out of my hole here!

Thanks so much,

Rachael

P.S. I promise to start helping others out when I've got more to grips with this! I don't like the idea that I'm using this forum for one-way advice only.

 

[Rach1978]

Sorry - should say I use Access 2000.

Many thanks,

Rachael

 

[GDGarth]

To implement security, you need to follow all the steps correctly.

There's a security FAQ that should lay it out pretty well for you. The basic steps are:

1. Create a new workgroup using WRKGADM.EXE. Don't just make a copy of System.mdw.

2. Join the new workgroup.

3. Create a new user name for yourself, and set a password for your user name. Put your user name into the "Admins" group.

4. Remove the default "admin" user from the "Admins" group (leave them in the "users" group).

5. Open your database and run the User Level Security Wizard. This will make a secure copy of your database without changing the original.

6. Open the new, secure database, and set up your user and group accounts. If you don't want the default user to have access to your database, set up a new user group, and remove all permissions from the existing user group.

This is the condensed version of Access Security. I recommend you read the instructions so you understand it before you implement it.