QueryDef Object, QueryDefs Collection Summary
QueryDef Object
A QueryDef object contains these collections, methods, and properties.
Legend:
Available only in a Microsoft Jet workspace.
Available only in an ODBCDirect workspace.
Collections
Fields ![]() |
| Parameters (default) |
| Properties |
Methods
Cancel ![]() |
| Close |
CreateProperty ![]() |
| Execute |
| OpenRecordset |
Properties
CacheSize ![]() |
| Connect |
DateCreated ![]() |
KeepLocal ![]() |
LastUpdated ![]() |
LogMessages ![]() |
| MaxRecords |
| Name |
| ODBCTimeout |
Prepare ![]() |
| RecordsAffected |
Replicable ![]() |
ReturnsRecords ![]() |
| SQL |
StillExecuting ![]() |
| 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