Beginning Access 2002 VBA (Programmer to Programmer)
| |
Methods
| Name | Returns | Description |
|---|---|---|
| Cancel | Cancels the execution of a pending ODBCDirect asynchronous call. | |
| Close | Closes the active connection. | |
| CreateQueryDef | QueryDef | Create a new QueryDef object. |
| Execute | Runs a SQL statement or an action query. | |
| OpenRecordset | Recordset | Opens a new recordset. |
Properties
| Name | Returns | Description |
|---|---|---|
| Connect | String | Defines the source of an open connection. |
| Database | Database | Defines the Database object for the current connection. Read-only. |
| Name | String | Identifies the name of the connection. If the Connection object is not yet appended to the Connections collection, this property is |
| QueryDefs | QueryDefs | Collection of QueryDef objects for this database. Read-only. |
| QueryTimeout | Integer | When connected to an ODBC data source, specifies the number of seconds to wait before an error is generated. The default is 60 . |
| RecordsAffected | Long | Contains the number of records affected by the last Execute method. Read-only. |
| Recordsets | Recordsets | Collection of Recordset objects open in this connection. Read-only. |
| StillExecuting | Boolean | For an ODBCDirect connection, identifies whether or not an asynchronous command has finished. Read-only. |
| Transactions | Boolean | Indicates whether or not the connection supports transactions. Read-only. |
| Updatable | Boolean | Indicates whether or not data in the connected database can be changed. Read-only. |
| Refresh | Updates the objects in the collection. |
| |