Access 2003 VBA Programmer's Reference

C.2. DAO-Supported Objects

C.2.1. Connections Collection

The Connections collection contains the current Connection objects of a Workspace object (ODBCDirect workspaces only).

C.2.1.1. Methods

Method	Description
Refresh	Refreshes the collection

C.2.1.2. Properties

Property	Description
Count	Returns a count of Connection objects in the collection (ODBCDirect workspaces only)

C.2.1.3. Connection Object

The Connection object is a connection to an ODBC database (ODBCDirect workspaces only).

C.2.1.3.1. Methods

Method	Description
Cancel	Cancels execution of a pending asynchronous method call (ODBCDirect workspaces only)
Close	Closes an open Connection object (ODBCDirect workspaces only)
CreateQueryDef	Creates a new QueryDef object in an ODBCDirect Connection (ODBCDirect workspaces only)
Execute	Runs an action query on an ODBCDirect Connection (ODBCDirect workspaces only)
OpenRecordset	Creates a new Recordset object (ODBCDirect workspaces only)

C.2.1.3.2. Properties

Property	Description
Connect	Sets/returns a value that indicates the source of an open connection (ODBCDirect workspaces only)
Database	Returns the Database object that corresponds to this connection (ODBCDirect workspaces only)
Name	Sets/returns the connection name. Read-only if the connection has already been added to the collection (ODBCDirect workspaces only)
QueryTimeout	Sets/returns a value that specifies the number of seconds to wait before a time-out error occurs when a query is executed on an ODBC data source (ODBCDirect workspaces ...