Connection

Methods

Name	Returns	Description
Cancel		Cancels the execution of a pending ODBCDirect asynchronous call.
Close		Closes the active connection.
CreateQueryDef	QueryDef	Create a new QueryDef object.
Execute		Runs a SQL statement or an action query.
OpenRecordset	Recordset	Opens a new recordset.

Properties

Name	Returns	Description
Connect	String	Defines the source of an open connection.
Database	Database	Defines the Database object for the current connection. Read-only.
Name	String	Identifies the name of the connection. If the Connection object is not yet appended to the Connections collection, this property is
QueryDefs	QueryDefs	Collection of QueryDef objects for this database. Read-only.
QueryTimeout	Integer	When connected to an ODBC data source, specifies the number of seconds to wait before an error is generated. The default is 60 .
RecordsAffected	Long	Contains the number of records affected by the last Execute method. Read-only.
Recordsets	Recordsets	Collection of Recordset objects open in this connection. Read-only.
StillExecuting	Boolean	For an ODBCDirect connection, identifies whether or not an asynchronous command has finished. Read-only.
Transactions	Boolean	Indicates whether or not the connection supports transactions. Read-only.
Updatable	Boolean	Indicates whether or not data in the connected database can be changed. Read-only.
Refresh		Updates the objects in the collection.