ADO dynamic properties

Applies to: Access 2013, Office 2013

Dynamic properties can be added to the Properties collections of the Connection, Command, or Recordset objects. The source for these properties is either a data provider, such as the OLE DB Provider for SQL Server, or a service provider, such as the Microsoft Cursor Service for OLE DB. Refer to the appropriate data provider or service provider documentation for more information about a specific dynamic property.

The ADO Dynamic Property Index provides a cross-reference between the ADO and OLE DB names for each standard OLE DB provider dynamic property.

The following dynamic properties are of special interest, and are also documented in the sources mentioned above. Special functionality with ADO is documented in the ADO help topics listed below.

Dynamic property	Description
Optimize	Specifies whether an index should be created on this field.
Prompt	Specifies whether the OLE DB provider should prompt the user for initialization information.
Reshape Name	Specifies a name for the Recordset object.
Resync Command	Specifies a user-supplied command string that the Resync method issues to refresh the data in the table named in the Unique Table dynamic property.
Unique Table, Unique Schema, Unique Catalog	Unique Table — specifies the name of the base table upon which updates, insertions, and deletions are allowed. Unique Schema — specifies the schema, or name of the owner of the table. Unique Catalog — specifies the catalog, or name of the database containing the table.
Update Resync	Specifies whether the UpdateBatch method is followed by an implicit Resync method operation, and if so, the scope of that operation.