ADO PropertyObject

Property Object

Built-in properties are properties that are implemented in ADO and are immediately available to any new object, using the MyObject.Property syntax. They do not appear as Property objects in the object's Properties collection, so although you can change their values, you cannot change their characteristics.

The ADO Property object represents a dynamic characteristic of an ADO object that is defined by the provider.

Each provider that communicates with ADO has a different way of interacting with ADO. Therefore, ADO needs a way to store information about the provider. The solution is for the provider to supply specific information (dynamic properties) to ADO. ADO stores each provider property in a Property object, and the Property objects are in turn stored in a Properties collection. This collection is assigned to a Command object, Connection object, Field object, or Recordset object.

For example, a property specific to a provider might indicate whether a Recordset object supports transactions or updates. These additional properties appear as Property objects in the Properties collection of that Recordset object.

ProgID

Properties