Security amateur

[Guest]

I have never set up user-level security in Access before, and I am now
attempting it with only the guidance of MS Help and this discussion board. I
have a work group of about 20, but we want to create three types of users:
the Admin, those with read-only access, and those with data read/write
access. To do this, I've tried using the User Level Security wizard twice
unsuccessfully. The first time, after completing the wizard, when I tried to
re-open the db, I got a message saying that I did not have permission to open
the database. I used the backup file to retry using the wizard, this time
giving Open/Run access to the database to the Users group. I also added two
user in the wizard, one with Read-only permissions and another with
Read/Write permissions. I then entered an Admin password (Tools>User and
Group Accounts) so that users would be required to log in to the db. When I
re-opened the db, it prompted me for a password, but it only recognized the
user Admin. I had to add users through Tools>User and Group Accounts. Now I
can log in as one of the users I created, but I don't know that these users
will have the intended permissions. What am I missing? Shouldn't the Wizard
set everything up? Should I I'm operating with Access 2000.

 

[Douglas J. Steele]

Unfortunately, the Wizard often does an incomplete job.

You're best off looking at the Security FAQ
http://support.microsoft.com/support/access/content/secfaq.asp

Read it carefully several times, work on a copy of your database, and make
sure you don't leave out any steps.

 

[Graham Wideman [Visio MVP]]

.... and you might also like:

http://grahamwideman.com/gw/tech/access/accesssec/index.htm

Graham