YouTip

# ADO Property Object * * * ## Property Object 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. An ADO Property object represents a dynamic characteristic of an ADO object, 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 that the provider supplies 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 the Command object, Connection object, Field object, or Recordset object. For example, properties assigned by the provider might indicate if a Recordset object supports transactions or updating. These additional properties will appear as Property objects in that Recordset object's Properties collection. ### ProgID set objProperty=Server.CreateObject("ADODB.property") * * * ### Properties | Property | Description | | --- | --- | | Attributes | Returns the attributes of a Property object | | Name | Sets or returns the name of a Property object | | Type | Returns the type of the Property | | Value | Sets or returns the value of a Property object |