Undo Security Wizard

[Guest]

A nameless person in my group, mumble mumble mumble, decided to see what
would happen if he ran the user level security wizard on the dbase I was
working on.

As usual, the security wizard blocked access to all my other dbases as well.
How do I UNDO the user level security wizard when I have NO idea how he, the
nameless, did not write down anything?

Access 2000

 

[Lynn Trapp]

Have "nameless" open the database with a user that is a member of the
Admins Group and do the following:

1. Put the Admin User in the Admins group, if it isn't already there.
2. Make sure that the Users Group has full permissions to all objects in
the database.
3. Clear the Admin User's password.
4. Use the workgroup administrator to join the default system.mdw file.

 

[Lynn Trapp]

Take a lesson. Don't give your users access to menu items that might cause
them to do troublesome things. People have an unending curiosity when it
comes to computer applications. If you let them see a choice, then they are
going to try to see what it does. In the future, create your own custom
menus and toolbars that limit what users can see and/or do.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Thanks Lynn. Nameless is home "sick" today. I am dragging his @!#$@#$ in
here if I have to go home and get him out of bed myself. I think he really
feels bad about what he did because I went "Freak Show" on him last night.

In this case, curiosity killed the cat. =)

RIP