Connection String Property Execute Method Connection Object Command ActiveConnection Property Recordset ActiveConnection Property PROPERTY: Record::ActiveConnection Implemented in version 2.5 variant or string = recordobject.ActiveConnection recordobject.ActiveConnection = string The ActiveConnection property sets or returns a string definition for a connection if the connection is closed, or returns a variant that is a reference to an open Connection object. This allows you to determine which Connection object will be used by a Command object to execute a command query, or to which Connection object that a Recordset object will be applied (opened). The default is a null reference object. 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. Code (VBScript): objRecord.ActiveConnection = strConnection Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information