Set up more than one workgroup to use the same secure database

You can give users in different Microsoft Access workgroups access to a secure database and its objects by creating a group account with an identical name and personal ID (PID) in each workgroup that you want to share the secure database. You then add users in each workgroup to that group account. This is useful if you want users at remote locations to manage their own workgroup membership.

1. Exit Microsoft Access.
   
   
2. Use the Workgroup Administrator to join one of the workgroups.

   How?

3. Start Microsoft Access, open a database, and then log on as a workgroup administrator (a member of the Admins group).
   
   
4. Create a group account, making sure to write down the exact case-sensitive group name and PID.

   How?

5. Add users to the new group.

   How?

   Note   You can add users to this group or delete them at any time.

6. Repeat steps 1 through 5 for each workgroup that will share the same secured database. In step 3, make sure to type exactly the same case-sensitive group name and PID as you did for the group account you created in the first workgroup.
   
   
7. Open the secure database you want to share between the workgroups and assign permissions to the new group.

   How?

Note   You can also have a workgroup administrator at a remote location add the same group to his or her workgroup information file by providing the administrator with the exact case-sensitive group name and PID you used to create that group in your workgroup information file.