Re: Trouble setting up security

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The Security FAQ is no doubt a comprehensive document, but it is very
difficult to understand. Joan Wild lists several links on her web site:
http://www.jmwild.com/Accesssecurity.htm
Joan has a summary version of setting up security, and provides links to
several other sites, including Lynn Trapp's site. In my experience, which
is limited and has frankly been quite frustrating so far, reading all of the
documents on Joan's site may help you to a better understanding than be
achieved through any single document. It's partly a question of
terminology. For instance, one of the documents tells you to cancel through
a dialog, but that doesn't actually mean to press the Cancel button.
Rather, it means to leave the password blank, and to click OK. Once I got
past that I could profitably return to the document that confused me on that
point, since it was quite clear and concise on other points.
One important point. User-level security is not easy. People will tell you
that all you need to do is follow the FAQ, but that is much easier said than
done. It is important to understand it, but it will take a lot of study.

"Mary A Perez" <MaryAPerez@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:300A950F-22E3-4A2B-81BF-E3E04741C3EE@xxxxxxxxxxxxxxxx
I'm trying to set-up security in Access 2002.
I was following the step by step instructions & created a new workgroup
file, then went to Tools, Security, Users and Group Accounts.
Created a new user & then when I went to delete the admin I received an
error, because I don't have the correct permissions to do this.
So, I called the help desk & they had to call back. I closed Access &
left
what I had done.
Now, help desk called & I went back to Tools, Security, User and Group
Accounts, & all permissions to add, delete, etc are grayed out, and there
are
no longer 3 tabs as there were before. The Groups tab is gone.
So, now what do I do? The help desk is searching, but I thought I would
try
here thinking it could be faster.
The help desk did say that I should have just put a password on Admin
since
I can't delete it, &they can't give me that permission.
Is it too late to set the passwords for the admin and the user name I
created?
Also, now when I go to Tools, Security, I can't click on "User and Group
Permissions" or "User-Level Security Wizard".
Have I totally screwed this up or is there a way to start over?
I'm so frustrated!!!!
The users want this "live" next week. That means I need to setup the
security, split the database & copy to all the users desktop.
UGH!!!!!!!!!!
HELP!
Thank you


.

Quantcast