Create a security administrator account

Create a security administrator account

To complete this procedure, you must be logged on as a member of the Admins group.

  1. Start Microsoft Access by using a secure workgroup.

    Important   To make sure your database is completely secure, don't use the default workgroup defined by the workgroup information file that was created when you installed Microsoft Access. You should make sure the workgroup information file that defines the workgroup you are using has been created by using a unique workgroup ID (WID) , and, if not, you should create a new file.

    For information on joining an existing workgroup, click . For information on creating a new workgroup information file, click .

  2. Open a database.

  3. On the Tools menu, point to Security, and then click User And Group Accounts.

  4. On the Users tab, click New.

  5. In the New User/Group dialog box, type the name of the administrator account and a personal ID (PID), and then click OK to create the new account.

    User names can range from 1 to 20 characters, and can include alphabetic characters, accented characters, numbers, spaces, and symbols, with the following exceptions:

    Caution   Be sure to write down the exact account name and PID entries, including whether letters are uppercase or lowercase, and keep them in a secure place. If you ever have to re-create the account, you must supply the same name and PID entries. If you forget or lose these entries, you can't recover them.

  6. In the Available Groups box, click Admins, and then click Add.

    Microsoft Access adds the new administrator account to the Admins group and displays Admins in the Member Of box.

Note   The PID entered in step 5 is not a password. Microsoft Access uses the PID and the user name as seeds for an encryption algorithm to generate a secure identifier for the user account. For information on creating passwords, click .