groups-collection-adox.md

title	Groups Collection (ADOX) | Microsoft Docs
ms.prod	sql
ms.prod_service	connectivity
ms.technology	connectivity
ms.custom
ms.date	01/19/2017
ms.reviewer
ms.topic	conceptual
apitype	COM
f1_keywords	Groups User::Groups Catalog::Groups
helpviewer_keywords	Groups collection [ADOX]
ms.assetid	09aa7b0a-69d5-4564-80a7-20ad8189670f
author	MightyPen
ms.author	genemi

Groups Collection (ADOX)

Contains all stored Group objects of a catalog or user.

Remarks

The Groups collection of a Catalog represents all of the catalog's group accounts. The Groups collection for a User represents only the group to which the user belongs.

The Append method for a Groups collection is unique for ADOX. You can:

• Add a new security group to the collection with the Append method.

The remaining properties and methods are standard to ADO collections. You can:

• Access a group in the collection with the Item property.

• Return the number of groups contained in the collection with the Count property.

• Remove a group from the collection with the Delete method.

• Update the objects in the collection to reflect the current database schema with the Refresh method.

Note

Before appending a Group object to the Groups collection of a User object, a Group object with the same Name as the one to be appended must already exist in the Groups collection of the Catalog.

This section contains the following topic.

• Groups Collection Properties, Methods, and Events

See Also

Catalog Object (ADOX)
Group Object (ADOX)