how to remove all workgroup security from access97 database?

[Timo]

I have to rewrite an Access97 database app in SQLServer. The
Access database has been secured with an MDW, for which I have the
passwords. I've copied the MDW and MDB onto my PC. First, I open
the workgroup file with this command:

C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /wrkgrp
"C:\docs\mydb.mdw /user myusername /pwd mypassword

and then I explictly open the data MDB with the Access File/Open
Database menu option. From this point, I can see all the tables,
and can also open the Security dialog on the Tools menu.

In the Security dialog, what is the simplest way to remove all
security, so that I can then delete the MDW and open the MDB
directly, or link to it from a DTS script?
Thanks!
Timo

 

[Rick Brandt]

I have to rewrite an Access97 database app in SQLServer. The
Access database has been secured with an MDW, for which I have the
passwords. I've copied the MDW and MDB onto my PC. First, I open
the workgroup file with this command:

C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /wrkgrp
"C:\docs\mydb.mdw /user myusername /pwd mypassword

and then I explictly open the data MDB with the Access File/Open
Database menu option. From this point, I can see all the tables,
and can also open the Security dialog on the Tools menu.

In the Security dialog, what is the simplest way to remove all
security, so that I can then delete the MDW and open the MDB
directly, or link to it from a DTS script?

Give the user "Admin" full rights by adding him to a group with admin
authority or by simply assigning him full permissions to the db and
objects. Then close Access and reopen it while joined to a non-secure MDW.

Create a new blank file and import all of the objects from your secure
file. Since you are always logged in as "Admin" when using a non-secure
MDW file you should have authority to do this after the first step above.

The file should now be the same as if it had never been secured in the
first place.

 

[Timo]

Thanks, Rick. After moving user Admin to Admins group, I can
export to another MDB, which is unsecured.
Timo