ADO: ActiveX Data Objects

Name

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

Synopsis

Dim property As ADODB.Property

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

Applies To

Properties

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

Properties

Attributes

Sets or returns specific characteristics about the Property object.

Name

Specifies the name for the current Property object.

Type

Indicates the datatype of the Property object’s value.

Value

Indicates the value of the current Property object.

Description

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.

Examples

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 ...