"Un"-securing a database

[rknmsp]

I have and Access 97 database (don't ask) that is set up under Access user level security. I want to do a conversion to a more current version of Access, but on a separate machine not attached to the production system. The test machine does not have Access security on it, nor do I want to enabled it as I have several other Access dbs that do not use the security protocol. Is there a way I can open this secure database in an environment that doesn't use security?

Thanks

 

[FancyPrairie]

You could export all of the objects from the secure database to an unsecure database (that would take awhile because you have to do each one individually).

Or you could create a new user account in the unsecured database (record the user name and Personal ID). Then create a new user account in the secured database (same name and personal id). Then make the new user a member of the Admins group. Then in the unsecured database, simply import all of the objects.

Or you could simply setup a shortcut for your new database so that it points to the workgroup file of the Access 97 database. Then it will still be secured without effecting the other database on the same machine. The path property of the shortcut would look something like this:

"\\path\msaccess.exe" "\\path\YourDatbase.mdb" /wrkgrp "\\path\YourAccess97WorkgroupFile.mdw

 

[FancyPrairie]

oops, hit the submit button rather then the edit button.

The other thing you could do is to grant full rights to user Admin and group Users in the secured database, then import your objects.

Note that even though the "test machine does not have Access security on it", it really does. The file System.mdw is on the machine and contains the default security settings. Where user Admin is a member of the Admins group which has total control.