In a Microsoft Access workspace, if you provide anything other than a zero-length string for the name when you create a
QueryDef, the resulting
QueryDef object is automatically appended to the
QueryDefs collection.
If the object specified by name is already a member of the
QueryDefs collection, a run-time error occurs. You can create a temporary
QueryDef by using a zero-length string for the name argument when you execute the
CreateQueryDef method. You can also accomplish this by setting the
Name property of a newly created
QueryDef to a zero-length string (""). Temporary
QueryDef objects are useful if you want to repeatedly use dynamic SQL statements without having to create any new permanent objects in the
QueryDefs collection. You can't append a temporary
QueryDef to any collection because a zero-length string isn't a valid name for a permanent
QueryDef object. You can always set the
Name and
SQL properties of the newly created
QueryDef object and subsequently append the
QueryDef to the
QueryDefs collection.
To remove a
QueryDef object from a
QueryDefs collection in a Microsoft Access database engine database, use the
Delete method on the collection.