Hello,

I use MDBSecure to secure my databases. I works well and is pretty easy.

Here is my problem. When we do debugging etc of our code that uses our
secured database, we sometimes need to remove all the restrictions on the DB
and reset the DB to a DB that uses the system.mdw file and is a regular
access database as if no permissions had been set. i.e. anybody can just
double click on the file and open it up in access, without all that password
stuff.

This unlocking is a real pain. I have to go to the security tab and select,
for every user, and every group, all the tables, all the  queries, all the
reports, etc and unset the permissions. This is a multi-step process and
takes a lot of time.

Is there some way (or utility) such that when I log into my database (so the
DB and its security mdw file verifies that I have permissions to unset the
permissions) that I can somehow just globally, with a button click just
reset everything to "open". i.e. reset it to the standard out of the box
Access admin permissions so the database can be opened with the system mdw
and without any password having to be entered?

Thanks
AK