ADO Record Object >> ActiveConnection Property

The ActiveConnection property sets or returns a string or variant that tells which Connection object the Record object belongs to.

If the connection is closed, it sets or returns a string definition for a connection. If the connection is open it sets or returns a variant that is a reference to the current Connection object. The default is a null reference object.

Tip: You can also use the ActiveConnection parameter of the Open method of the Record object to set this property. When a Record is opened from an already existing Record or Recordset, it will automatically be set to the Connection object associated with the Record or Recordset. Similarly, when a Record object is opened from a URL, a Connection object is implicitly set.

Syntax

variant or string =objrecord.ActiveConnection

Example

objRecord.ActiveConnection = strConnection