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 ... |
Get Access 2003 VBA Programmer's Reference now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.