Removing Security

[Tawne]

We are having problems with the security set up in
Access. I set it up. It was working and now it still
looks like each user is set up but it no longer requests
they login. In addition, it is defaulting to the Admin
login.

Is there a way to remove all security rights and starting
over? (It won't allow me to remove users or change rights
in Access anymore. The buttons are not grayed out).

 

[JR]

Hi,
To force the Logon dialog box at Access startup, you'll have to set a
non-blank password for the built-in user account: "Admin".

To remove user-level security, you'll have to proceed as indicated in the
item 34 (How can I "de-secure" a database?) of the MS Security FAQ:
http://support.microsoft.com/support/access/content/secfaq.asp

HTH