Connection Members (DAO)
Last modified: March 09, 2015
Applies to: Access 2013 | Office 2013
Note
|
|---|
|
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.A Connection object represents a connection to an ODBC database (ODBCDirect workspaces only). |
|
Name |
Description |
||
|---|---|---|---|
|
Cancels execution of a pending asynchronous method call (ODBCDirect workspaces only). |
|||
|
Closes an open Connection. |
|||
|
Creates a new QueryDef object. |
|||
|
Runs an action query or executes an SQL statement on the specified object. |
|||
|
Creates a new Recordset object and appends it to the Recordsets collection. |
|
Name |
Description |
||
|---|---|---|---|
|
Sets or returns a value that provides information about the source of an open connection. Read/write String. |
|||
|
Returns the Database object that corresponds to this connection (ODBCDirect workspaces only). |
|||
|
Rreturns the name of a Connection. |
|||
|
Returns a QueryDefs collection that contains all of the QueryDef objects of the specified connection. Read-only. |
|||
|
Sets or returns a value that specifies the number of seconds to wait before a timeout error occurs when a query is executed on an ODBC data source. |
|||
|
Returns the number of records affected by the most recently invoked Execute method. |
|||
|
Returns a Recordsets collection that contains all of the open recordsets in the for the specified connection. Read-only. |
|||
|
Indicates whether or not an asynchronous operation (that is, a method called with the dbRunAsync option) has finished executing (ODBCDirect workspaces only). |
|||
|
Returns a value that indicates whether an object supports transactions. Read-only Boolean. |
|||
|
Returns a value that indicates whether you can change a DAO object. Read-only Boolean.Read-only. |