Navigation:  DAO Object Classes >

DaoConnection Class

Previous pageReturn to chapter overviewNext page

Purpose

A connection represents the information of an open ODBC connection

 

Accesses/Assigns

ConnectInformation saved from the Connect argument of the OpenDatabase
DatabaseReturns a Database reference to this Connection object
NameThe name of this object
QueryDefsCollection of QueryDef objects for this connection
QueryTimeOutNumber of seconds before timeout occurs when executing an ODBC query
RecordsAffectedNumber of records affected by the last Execute() Method
RecordsetsCollection of recordset objects open in this connection
StillExecutingIndicates whether an asynchronous() Method call is still executing
TransactionsIndicates whether the DAO object supports transactions.
UpdatableIndicates whether the connection allows data to be updated

 

Methods

CancelCancels execution of an asynchronous Execute or OpenRecordset() Method.
CloseClose the Connection object and everything it contains
CreateQueryDefCreates a new QueryDef object
ExecuteExecute an SQL statement
OpenRecordsetCreates a new Recordset object

 

See Also

DaoConnections

 

Example

Connection sample