Navigation:  DAO Object Classes > DaoRecordset Class >

DaoRecordset:Update() Method

Previous pageReturn to chapter overviewNext page


Saves the contents of the copy buffer to an updatable Recordset object.



sType(Optional) A constant indicating the type of update, as specified in Settings (ODBCDirect workspaces only).
bForce(Optional) A Logical  value indicating whether or not to force the changes into the database, regardless of whether the underlying data has been changed by another user since the AddNew, Delete, or Edit call. If True, the changes are forced and changes made by other users are simply overwritten. If False (default), changes made by another user while the update is pending will cause the update to fail for those changes that are in conflict. No error occurs, but the BatchCollisionCount and BatchCollisions properties will indicate the number of conflicts and the rows affected by conflicts, respectively (ODBCDirect workspaces only).



You can use the following values for the sType argument. You can use the non-default values only if batch updating is enabled




dbUpdateRegularDefault. Pending changes aren't cached and are written to disk immediately.
dbUpdateBatchAll pending changes in the update cache are written to disk.
dbUpdateCurrentRecordOnly the current record's pending changes are written to disk



Use Update to save the current record and any changes you've made to it.


Caution Changes to the current record are lost if:

You use the Edit or AddNew method, and then move to another record without first using Update.
You use Edit or AddNew, and then use Edit or AddNew again without first using Update.
You set the Bookmark property to another record.
You close the Recordset without first using Update.
You cancel the Edit operation by using CancelUpdate.