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.