QueryDefTypeEnum enumeration (DAO)

Applies to: Access 2013, Office 2013

Used with the Type property to specify the type of QueryDef object.

Name

Value

Description

dbQAction

240

Action query

dbQAppend

64

Append query

dbQCompound

160

Compound query

dbQCrosstab

16

Crosstab query

dbQDDL

96

Data-definition language (DDL) query

dbQDelete

32

Delete query

dbQMakeTable

80

Make-table query

dbQProcedure

224

SQL procedure that executes a stored procedure

dbQSelect

0

Select query

dbQSetOperation

128

Set operation query

dbQSPTBulk

144

Bulk operation query

dbQSQLPassThrough

112

SQL pass-through query

dbQUpdate

48

Update query