QueryDef.Type property (DAO)

Applies to: Access 2013, Office 2013

Sets or returns a value that indicates the operational type or data type of an object. Read-onlyInteger.

Syntax

expression .Type

expression A variable that represents a QueryDef object.

Remarks

For a QueryDef object, the possible settings and return values are shown in the following table.

Constant	Query type
dbQAction	Action
dbQAppend	Append
dbQCompound	Compound
dbQCrosstab	Crosstab
dbQDDL	Data-definition
dbQDelete	Delete
dbQMakeTable	Make-table
dbQProcedure	Procedure (ODBCDirect workspaces only) NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
dbQSelect	Select
dbQSetOperation	Union
dbQSPTBulk	Used with dbQSQLPassThrough to specify a query that doesn't return records (Microsoft Access workspaces only).
dbQSQLPassThrough	Pass-through (Microsoft Access workspaces only)
dbQUpdate	Update

When you append a new Field, Parameter, or Property object to the collection of an Index, QueryDef, Recordset, or TableDef object, an error occurs if the underlying database doesn't support the data type specified for the new object.