You need to create a shortcut to your mdb which utilizes the mdw file (most likely the mdw is called System.mdw and can usually be found in a folder.) example of a shortcut file: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Databases\MyMDBFileName.mdb" /wrkgrp "C:\Windows\Application Data\Microsoft\Access\System.MDW"
Here's some more info which may be helpful regarding mdw and security: http://www.headwaysystems.com/accessSecurity.htm and http://support.microsoft.com/kb/305542
Once you open the mdb via the shortcut, you'll get a prompt for the user name and password. Then remove the security of the mdw. You may want to make a backup of the mdw file (don't just delete it.) If the username and password you enter still do not give you permissions, I've attached a utility which lets you browse for the mdw file and see the usernames and passwords in it. Unzip the attachment and open the UPVMSA2K.MDA file to use it.
Last edited by pkstormy; 12-15-07 at 01:24.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)