Is Security Implementations reversable?

[Lynn Trapp]

1. Log on to your database as a member of the Admins Group.
2. Grant full permissions on all objects to the Users Group.
3. Add the Admin User back to the Admins Group.
4. Clear the Admin User's password.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Leo Muller]

Hi,

I am kind of reluctant to implement the security (wizard) , because I have
found no way back from this. Maybe someone here knows if and how this can be
done, in case I need to.

So basically I want to know how I can undo all security settings of an MDB
database, and recreate an open for everyone database. Of course I DO have an
admin password.

Thanks,

Leo

 

[Joan Wild]

Hi,

I am kind of reluctant to implement the security (wizard) , because I have
found no way back from this. Maybe someone here knows if and how this can
be done, in case I need to.

Depending on version, the wizard offers to make a backup. Nonetheless, why
not just make a copy of your unsecured database before going with the
wizard?

 

[Leo Muller]

I know it will make a backup,

But once I start working on the secured version, I can't move backwards.
(loosing data, additions, etc).

Leo

 

[Rick Brandt]

I know it will make a backup,

But once I start working on the secured version, I can't move backwards.
(loosing data, additions, etc).

Unless you screw up and lock yourself out removing security is trivial.