O'Reilly logo

Access 2003 VBA Programmer's Reference by Armen Stein, Graham Seach, Teresa Hennig, Patricia Cardoza

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required