Access Database Design and Programming, Second Edition

Connection Object (DAO 3.5 Only)

Collections

Property	Type	Version	Description
Database	Database	3.5	Returns a Database reference to this Connection object
QueryDefs	QueryDefs	3.5	A collection of QueryDef objects
Recordsets	RecordSets	3.5	A collection of Recordset objects open in this connection

Methods

Method	Parameters	Returns	Version	Description
Cancel		Sub	3.5	Cancels execution of an asynchronous Execute or OpenRecordset method
Close		Sub	3.5	Closes the Connection object and everything it contains
CreateQueryDef	[Name], [SQLText])	QueryDef	3.5	Creates a new QueryDef object
Execute	Query As String, [Options]	Sub	3.5	Executes an SQL statement
OpenRecordSet	Name As String, [Type], [Options], [LockEdit]	Recordset	3.5	Creates a new Recordset object

Properties

Property	Type	Version	Description
Connect	String	3.5	Information saved from the Connect argument of the OpenDatabase method
Name	String	3.5	Name of the Connection object
QueryTimeout	Integer	3.5	Number of seconds before timeout occurs when executing an ODBC query
RecordsAffected	Long	3.5	Number of records affected by the last Execute method
StillExecuting	Boolean	3.5	Indicates whether an asynchronous method call is still executing
Transactions	Boolean	3.5	Indicates whether the DAO object supports transactions
Updatable	Boolean	3.5	Indicates whether the connection allows data to be updated