Microsoft KB Archive/918583

= How to use the Workgroup Administrator utility in Access 2007 =

Article ID: 918583

Article Last Modified on 11/3/2006

-

APPLIES TO


 * Microsoft Office Access 2007

-



This article applies to Microsoft Access .mdb files and .accdb files.





INTRODUCTION
This article describes how to use the Workgroup Administrator utility in Microsoft Office Access 2007.

Note User-level security does not exist in an .accdb file, even though you can run the Workgroup Administrator utility from an .accdb file in Access 2007.



MORE INFORMATION
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:  In Access 2007, open a trusted database, or enable macros in the existing database. Press CTRL + G to open the Immediate window. Type the following line of code, and then press ENTER.

DoCmd.RunCommand acCmdWorkgroupAdministrator

  Create a module that contains the Visual Basic code:  In Access 2007, open a trusted database, or enable macros in the existing database.</li> On the Create tab, in the Other group, click Macro, and then click Module.</li>  Create a subroutine, and then paste the following Visual Basic code example into the subroutine. DoCmd.RunCommand acCmdWorkgroupAdministrator </li> Press F5 to run the code.</li></ol> </li></ul>

Method 2: Use the RunCommand macro action

 * 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 Macro.
 * 3) On the Design tab, click Show All Actions in the Show/Hide group.
 * 4) On the Macro1 tab, click RunCommand in the Action column, and then click WorkgroupAdminstrator in the Command list.
 * 5) Click Save.
 * 6) In the Tools group, click Run.

Additional query words: AC2007 ACC2007 Access2007

Keywords: kbexpertisebeginner kbinfo kbhowto KB918583

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.