ACC: Overview of How to Help Protect a Microsoft Access Database

MORE INFORMATION

• You create the database and its objects while you are logged in as the Admin user.
• You do not remove the default Users group permissions that are granted in full for all objects.
• Your distributed application includes the same SYSTEM.MDA file used to create the database. In the SYSTEM.MDA, the Admin account has no password and is a member of the Admins group.

1. Open the Workgroup Administrator (WRKGADM.EXE) file and create a new system database (SYSTEM.MDA in versions 1.0 and 2.0; SYSTEM.MDW for version 7.0 or later) that has a unique Name, Organization, and Workgroup ID.
2. Start Microsoft Access and open any database.
3. On the Security menu, click Change Password. Assign a password to the Admin user account.
4. On the Security menu, click Users. Create a new user account, and then add the account to the Admins group.
5. In the Users box, select the Admin user name. Remove the Admin account from the Admins group.
6. On the File menu, click Exit. Restart Microsoft Access and log in as the new user you created in step 4.
7. Create a new database.
8. On the Security menu, click Permissions. By making the selections in the Object Type box, remove the default Users group permissions for the following objects that appear in the Object Name box:
   

         - <Current Database>
         - <New Tables/Queries>
         - <New Forms>
         - <New Reports>
         - <New Macros>
         - <New Modules>
   						

9. Import all of the objects from your original database into the new database.
10. Create other group and user accounts as necessary.
11. Assign group and user permissions to your objects as appropriate.
12. Close the database, and then use the Encrypt/Decrypt Database command to encrypt the database. (This step is optional.)