Connection Object (DAO 3.5 Only)

Collections

Property

Type

Version

Description

Database

Database

3.5

Returns a Database reference to this Connection object

QueryDefs

QueryDefs

3.5

A collection of QueryDef objects

Recordsets

RecordSets

3.5

A collection of Recordset objects open in this connection

Methods

Method

Parameters

Returns

Version

Description

Cancel

 

Sub

3.5

Cancels execution of an asynchronous Execute or OpenRecordset method

Close

 

Sub

3.5

Closes the Connection object and everything it contains

CreateQueryDef

[Name], [SQLText])

QueryDef

3.5

Creates a new QueryDef object

Execute

Query As String, [Options]

Sub

3.5

Executes an SQL statement

OpenRecordSet

Name As String, [Type], [Options], [LockEdit]

Recordset

3.5

Creates a new Recordset object

Properties

Property

Type

Version

Description

Connect

String

3.5

Information saved from the Connect argument of the OpenDatabase method

Name

String

3.5

Name of the Connection object

QueryTimeout

Integer

3.5

Number of seconds before timeout occurs when executing an ODBC query

RecordsAffected

Long

3.5

Number of records affected by the last Execute method

StillExecuting

Boolean

3.5

Indicates whether an asynchronous method call is still executing

Transactions

Boolean

3.5

Indicates whether the DAO object supports transactions

Updatable

Boolean

3.5

Indicates whether the connection allows data to be updated

Get Access Database Design and Programming, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.