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

CREATE USER or GROUP Statement

Applies to: Microsoft Office Access 2007

 

Creates one or more new users or groups.

Syntax

Create a user:

CREATE USER user password pid [, user password pid, …]

Create a group:

CREATE GROUP group pid[, group pid, …]

The CREATE USER or GROUP statement has these parts:

Part Description
user The name of a user to be added to the workgroup information file.
group The name of a group to be added to the workgroup information file.
password The password to be associated with the specified user name.
pid The personal id.
Remarks

A user and a group cannot have the same name.

A password is required for each user or group that is created.