Class Properties (ADODB VBA)

Contains all the Property objects for a specific instance of an object. To use a Properties class variable it first needs to be instantiated, for example

Count

Indicates the number of objects in a collection.

Use the Count property to determine how many objects are in a given collection. Because numbering for members of a collection begins with zero, you should always code loops starting with the zero member and ending with the value of the Count property minus 1. If you are using Microsoft Visual Basic and want to loop through the members of a collection without checking the Count property, use the For Each...Next command. If the Count property is zero, there are no objects in the collection.

Item

Indicates a specific member of a collection, by name or ordinal number.

Use the Item property to return a specific object in a collection. If Item cannot find an object in the collection corresponding to the Index argument, an error occurs. Also, some collections don't support named objects; for these collections, you must use ordinal number references. The Item property is the default property for all collections; therefore, the following syntax forms are interchangeable:

Item (Index)

Index: A Variant expression that evaluates either to the name or to the ordinal number of an object in a collection.

Refresh

Updates the objects in a collection to reflect objects available from, and specific to, the provider.

The Refresh method accomplishes different tasks depending on the collection from which you call it.