QueryDef Object, QueryDefs Collection Summary

 

QueryDef Object

A QueryDef object contains these collections, methods, and properties.

Legend:

jetAvailable only in a Microsoft Jet workspace.

daoodbcAvailable only in an ODBCDirect workspace.

Collections

Fields jet

Parameters (default)

Properties

 

Methods

Cancel daoodbc

Close

CreateProperty jet

Execute

OpenRecordset

 

Properties

CacheSize daoodbc

Connect

DateCreated jet

KeepLocal jet

LastUpdated jet

LogMessages jet

MaxRecords

Name

ODBCTimeout

Prepare daoodbc

RecordsAffected

Replicable jet

ReturnsRecords jet

SQL

StillExecuting daoodbc

Type

Updatable

 

QueryDefs Collection

A QueryDefs collection appears in each Connection object in an ODBCDirect workspace, and each Database object, and contains these methods and this property.

Methods

Append

Delete

Refresh

 

Property

Count