UpdateCriteriaEnum enumeration (DAO)

Applies to: Access 2013, Office 2013

Used with the UpdateOptions method to specify how a batch update is constructed.

Name

Value

Description

dbCriteriaAllCols

4

Uses the key column(s) and all the columns in the where clause.

dbCriteriaDeleteInsert

16

Uses a pair of DELETE and INSERT statements for each modified row.

dbCriteriaKey

1

Uses just the key column(s) in the where clause.

dbCriteriaModValues

2

Uses the key column(s) and all updated columns in the where clause.

dbCriteriaTimestamp

8

Uses just the timestamp column if available (will generate a run-time error if no timestamp column is in the result set).

dbCriteriaUpdate

32

Uses an UPDATE statement for each modified row.