How to Join Workgroups in MS Access 2007

Save

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.

  • Open the Microsoft Access 2007 application on your computer. Click on the “Microsoft Office” button and then click on the “Open” option.

  • Locate the database you want to use from the “Open” dialog box. Select the database file and then click on the “Open” button.

  • Press the “Control” and “G” keys within the database and the “Immediate” window will open.

  • Enter “DoCmd.RunCommand acCmdWorkgroupAdministrator” into the command line and then press the “Enter” key on your keyboard.

  • Click on the “Join” button in the “Workgroup Administrator” dialog box. Click on the “Browse” button and click on the “C:” drive folder.

  • 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.

  • Click on the “OK” button in the “Workgroup Administrator” dialog box. Click on the “Exit” button and you will have successfully joined the workgroup.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!