Connection Property

On a Database object, returns the Connection object that corresponds to the database (ODBCDirect workspaces only).

On a Recordset object, returns the Connection object that owns the Recordset (ODBCDirect workspaces only).

Settings And Return Values

The return value is an object variable that represents the Connection. On a Database object, the Connection property is read-only, while on a Recordset object the property is read-write.

Remarks

On a Database object, use the Connection property to obtain a reference to a Connection object that corresponds to the Database. In DAO, a Connection object and its corresponding Database object are simply two different object variable references to the same object. The Database property of a Connection object and the Connection property of a Database object make it easier to change connections to an ODBC data source through the Microsoft Jet database engine to use ODBCDirect.