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. |