Search all of Office.com
 
Support / Access / Access 2007 Help and How-to / Macros and programmability / SQL reference
 
 

ADD USER Statement

Applies to: Microsoft Office Access 2007

 

Adds one or more existing users to an existing group.

Syntax

ADD USER user[, user, …] TO group

The ADD USER statement has these parts:

Part Description
user The name of a user to be added to the workgroup (workgroup: A group of users in a multiuser environment who share data and the same workgroup information file.) information file.
group The name of a group to be added to the workgroup information file.
Remarks

Once a user had been added to a group, the user has all the permissions that have been granted to the group.