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

DROP USER or GROUP Statement

Applies to: Microsoft Office Access 2007

 

Deletes one or more existing users or groups, or removes one or more existing users from an existing group.

Syntax

Delete one or more users or remove one or more users from a group:

DROP USER user[, user, …] [FROM group]

Delete one or more groups:

DROP GROUP group[, group, …]

The DROP USER or GROUP statement has these parts:

Part Description
user The name of a user to be removed from 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 removed from the workgroup information file.
Remarks

If the FROM keyword is used in the DROP USER statement, then each of the users listed in the statement will be removed from the group specified following the FROM keyword. However, the users themselves will not be deleted.

The DROP GROUP statement will delete the specified group(s). The users who are members of the group(s) will not be affected, but they will no longer be members of the deleted group(s).

 
 

See Also