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
MethodDescription
RefreshRefreshes the collection
C.2.1.2. Properties
PropertyDescription
CountReturns 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
MethodDescription
CancelCancels execution of a pending asynchronous method call (ODBCDirect workspaces only)
CloseCloses an open Connection object (ODBCDirect workspaces only)
CreateQueryDefCreates a new QueryDef object in an ODBCDirect Connection (ODBCDirect workspaces only)
ExecuteRuns an action query on an ODBCDirect Connection (ODBCDirect workspaces only)
OpenRecordsetCreates a new Recordset object (ODBCDirect workspaces only)
C.2.1.3.2. Properties
PropertyDescription
ConnectSets/returns a value that indicates the source of an open connection (ODBCDirect workspaces only)
DatabaseReturns the Database object that corresponds to this connection (ODBCDirect workspaces only)
NameSets/returns the connection name. Read-only if the connection has already been added to the collection (ODBCDirect workspaces only)
QueryTimeoutSets/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 ...

Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.