ADO: ActiveX Data Objects

Name

Record.ActiveConnection Property — (Versions 2.5, 2.6)

Synopsis

                     Record.ActiveConnection = ConnectionString
Set Record.ActiveConnection = ConnectionObject
                  

The ActiveConnection property indicates to which Connection object the current Record object belongs.

Datatype

String or Variant (containing the current Connection object)

Description

The ActiveConnection property of the Record object is both read- and write-enabled while the Record object is closed and read-only once it is opened. This property can be set to either a connection string or a Connection object and returns a Connection object when it is read.

If the Record object was opened from an existing Record object or a Recordset object, then the Record object gains its Connection object from this object. If the Record object is opened by using a URL, a Connection object is automatically created for the Record object and is accessible from the ActiveConnection property.

See Also

Record.Open Method