CREATE USER or GROUP Statement (Microsoft Access SQL)

Office 2013 and later

Last modified: March 09, 2015

Applies to: Access 2013 | Office 2013

Creates one or more new users or groups.

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.

A user and a group cannot have the same name.

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

Show: