Applies ToAccess for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013

Creates one or more new users or groups.

Syntax

Create a user:

CREATE USER userpassword pid [, userpassword pid, …]

Create a group:

CREATE GROUP grouppid[, grouppid, …]

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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.