Property Object — (Versions 2.0, 2.1, 2.5, 2.6)


Dim property As ADODB.Property

The Property object contains information about dynamic properties implemented by the associated data provider.

Applies To


This collection contains a group of Property objects that hold information about the functionality of a data provider.



Sets or returns specific characteristics about the Property object.


Specifies the name for the current Property object.


Indicates the datatype of the Property object’s value.


Indicates the value of the current Property object.


Individual Property objects are part of Properties collections for the Connection, Command, Recordset, and Field objects.

An instance of a Property object represents a single Dynamic property for the given data provider. The values of these properties, when changed, can alter the behavior of a data provider to a lower level than with the built-in properties of the given ADO object.


In this section, we will be looking at two examples that show how to do the following:

  • Display the dynamic properties of the Connection object.

  • Modify the value of a dynamic property.

Before we begin looking at the Property examples for this section, define the following connection string Const value so that the examples will work properly:

Private Const DATASOURCE_NWIND = "Provider=Microsoft.Jet.OLEDB.4.0; " _
                            & "Data Source=C:\Program Files\" _
                            & "Microsoft Visual Studio\VB98\NWind.mdb;"

Now that we have ...

Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.