Making a secured database to Unsecured

[Sumesh]

I have an unsecured xxx.mdb file.

I am securing this xxx.mdb file by creating a ggg.mdw
file using User-Level Security Wizard in MSAccess 2000.

It also creates a shortcut for me and I am able get into
the database by using the username and password.
Everything works great.

Now I want the same xxx.mdb file be bring back to the
original state. I mean make it again an unsecured one.
How to remove the security ? It should never ask for
ggg.mdw file.

Appreciate your valuable time.

Thanks and Regards
Sumesh

 

[Joan Wild]

If you used the security wizard, I believe that it creates a backup of your
unsecured mdb (it should be in the same folder as the secure mdb). Just
open it.

If you chose not to make a backup, you can follow the steps in the security
FAQ to unsecure a database.
http://support.microsoft.com/?kbid=207793

 

[Joan Wild]

In that case you can unsecure it 3 months later by following the steps
outlined in section 34 of the FAQ
http://support.microsoft.com/?kbid=207793
Login in as a member of the Admins group. Grant full permissions to the
Users group and Admin user. Put the Admin user back into the Admins group
and then remove the password from the Admin user.

You'll then be able to open the database using the default system.mdw with
no login prompt.

Then create a new database and import all objects from your database. This
will ensure that ownership is transferred to the Admin user.
That's it.