Microsoft Access 2007 Workgroup Administrator

[sjj1805]

To use the Workgroup Administrator in earlier versions of Access, you could click Workgroup Administrator in Security on the Tools menu. To use the Workgroup Administrator utility in Access 2007, use one of the following methods.
Method 1: Use Visual Basic code
To use Visual Basic code, use one of the following methods.
• Run the Visual Basic code in the Immediate window:
1. In Access 2007, open a trusted database, or enable macros in the existing database.
2. Press CTRL + G to open the Immediate window.
3. Type the following line of code, and then press ENTER.
DoCmd.RunCommand acCmdWorkgroupAdministrator
• Create a module that contains the Visual Basic code:
1. In Access 2007, open a trusted database, or enable macros in the existing database.
2. On the Create tab, in the Other group, click Macro, and then click Module.
3. Create a subroutine, and then paste the following Visual Basic code example into the subroutine.

DoCmd.RunCommand acCmdWorkgroupAdministrator

4. Press F5 to run the code.