Updating Data Differences between ADO and DAO

If you have ever used the older DAO Object Model to update and delete data (or plan on converting old DAO code to ADO), you must keep in mind how ADO differs from DAO in the way these operations are performed. In DAO, you were required to use the Edit method of the Recordset object prior to making any changes to your data. ADO does not require you to do this; consequently, there is no Edit method in ADO. Also, in ADO, if you modify a record, your changes are automatically saved. In DAO, leaving a row without first calling the Update method of the Recordset object will automatically discard your changes. You will find examples of working with DAO in the AppendixA.pdf file located in the book's downloadable files.