QueryDef Object, QueryDefs Collection Summary (DAO)
From Microsoft DAO 3.60
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
| Count |