ADO » Collections » Properties

The Properties Collection is a collection of Property objects. Each Property object contains a single piece of information, called a dynamic property, about the database provider. By referring to the Properties Collection, each connection to a provider can be tailored specifically by ADO to suit the exact needs of that provider.

This ability to be flexible when handling the various idiosyncrasies of individual database providers greatly enhances the usefulness of ADO.
The Command, Connection, Field, Parameter, Record and Recordset objects have access to the Properties Collection.
The Properties Collection has two properties and one method.



The Count property returns a long value that is the number of items in the collection. The counting starts at zero. You can use this value to loop through the collection by iterating from zero to the value of Count minus one.


The Item property is used to return a specific member of the Properties Collection. The Index parameter is a variant. It can be the named item or the position (ordinal) number.



The Refresh method updates the Property objects in the Properties Collection with the dynamic property information specific to the provider. It is quite possible that the provider has dynamic properties that are not supported by ADO.

See Also: