ADO Property Object

Property Object

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

The ADO Property object represents the dynamic characteristics of an ADO object, which are defined by the provider.

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

For example, provider-specific properties might indicate whether a Recordset object supports transactions or updates. These additional properties will appear as Property objects in the Recordset object's Properties collection.

ProgID

Properties