Share via

Property Object (ADO)

  • Article

Represents a dynamic characteristic of an ADO object that is defined by the provider.

Remarks

ADO objects have two types of properties: built-in and dynamic.

Built-in properties are those properties implemented in ADO and immediately available to any new object, using the

  MyObject.Property

syntax. They do not appear as Property objects in an object's Properties collection, so although you can change their values, you cannot modify their characteristics.

Dynamic properties are defined by the underlying data provider, and appear in the Properties collection for the appropriate ADO object. For example, a property specific to the provider may indicate if a Recordset object supports transactions or updating. These additional properties will appear as Property objects in that Recordset object's Properties collection. Dynamic properties can be referenced only through the collection, using the

  MyObject.Properties(0)

or

  MyObject.Properties("Name")

syntax.

You cannot delete either kind of property.

A dynamic Property object has four built-in properties of its own:

  • The Name property is a string that identifies the property.
  • The Type property is an integer that specifies the property data type.
  • The Value property is a variant that contains the property setting. Value is the default property for a Property object.
  • The Attributes property is a long value that indicates characteristics of the property specific to the provider.

See Also

Property Object Properties, Methods, and Events | Command Object | Connection Object | Field Object | Properties Collection | Recordset Object