UpdateCriteriaEnum Enumeration (DAO)
Last modified: March 09, 2015
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. |