Remove Security
  1. Login to your secure mdb using the username of someone in the Admins Group, or the owner of the database.
  2. Go to Tools, Security, User and Group Permissions.
  3. Grant full permissions on all objects to the Users Group.
  4. Go to Tools, Security, Workgroup Administrator and verify that your default workgroup file is the standard system.mdw that ships with Access.  (If you are using either 97 or 2000, go to Start, Run and type wrkgadm.exe to get to the Workgroup Administrator.)
  5. Close Access, and reopen it.  Create a new mdb and import all objects from your secure mdb.
  6. This new mdb is now unsecured.
 
     

Home | Access Tips | Clients | Links

Copyright 2007 - Joan Wild