Remove user-level security

Remove user-level security

This procedure requires a two-stage process. First, you log on as a workgroup administrator and give the Users group permissions on all tables, queries, forms, reports, and macros. Next you return ownership of the database and these objects to the default Admin user by exiting and logging on as Admin, creating a blank database, and then importing all of the objects from the original database into the new database.

  1. Start Microsoft Access.

  2. Open the database.

  3. Log on as a workgroup administrator (a member of the Admins group).

  4. Give the Users group full permissions on all tables, queries, forms, reports, and macros in the database.

    How?

  5. Exit and restart Microsoft Access, open a database, and then log on as Admin.

  6. Create a new blank database, and leave it open.

  7. Import all the objects from the original database into the new database.

    How?

  8. If users will be using the current workgroup information file when opening the database, you need to clear the password for Admin to turn off the Logon dialog box for the current workgroup. This is not necessary if users will be using the default workgroup information file created when installing Microsoft Access.

The new database is now completely unsecured. Anyone who can open the new database has full permissions on all the tables, queries, forms, reports, and macros in it. These permissions work for any workgroup because the Admin account is the same in every workgroup information file. The workgroup information file that was current when the new database was created in step 6 defines the Admins group for the new database.