How to Join Workgroups in MS Access 2007
By Greg Lindberg
When you create a Microsoft Access database (.mdb) file in Microsoft Access 2007, you can set up a workgroup information file containing information about the users in a workgroup. A workgroup is an environment within a database where multiple users can share data. You easily can join a workgroup using the Workgroup Administrator tool in Access 2007. You will then be able to work with other users collaboratively to make changes to the database.
Step 1
Open the Microsoft Access 2007 application on your computer. Click on the “Microsoft Office” button and then click on the “Open” option.
Step 2
Locate the database you want to use from the “Open” dialog box. Select the database file and then click on the “Open” button.
Step 3
Press the “Control” and “G” keys within the database and the “Immediate” window will open.
Step 4
Enter “DoCmd.RunCommand acCmdWorkgroupAdministrator” into the command line and then press the “Enter” key on your keyboard.
Step 5
Click on the “Join” button in the “Workgroup Administrator” dialog box. Click on the “Browse” button and click on the “C:” drive folder.
Step 6
Click on the “Program Files” folder and then click on the “Common Files” folder. Click on the “system” folder and then click on the “System.mdw” file, which contains the system information for the Access 2007 database. Click on the “Open” button.
Step 7
Click on the “OK” button in the “Workgroup Administrator” dialog box. Click on the “Exit” button and you will have successfully joined the workgroup.