The QueryDef object represents a temporary definition of a query in an ODBCDirect workspace. The QueryDefs collection contains all QueryDef objects that currently exist in the workspace. The following table shows the relationship between the QueryDef object and the QueryDefs collection and other objects and collections in an ODBCDirect workspace.
Object or collection | Is contained by | Contains |
QueryDef object | QueryDefs collection | Parameters collection |
Properties collection | ||
QueryDefs collection | Connection object | QueryDef objects |
Unlike QueryDef objects created in a Microsoft Jet workspace, QueryDef objects created in an ODBCDirect workspace are always temporary — they are not saved within the data source before they run, even if you assign them a name.