You can perform CRUD (Create, Read, Update, and Delete) operations on most dynamic Recordsets with VBA code. To test whether a Recordset is editable, check the value of the Updatable property. You can't edit Forward-Only or Snapshot-type Recordsets, and most dynamic queries with INNER or OUTER JOINs aren't editable.
Don't apply Edit, AddNew, Update, or Delete methods to a Recordset created from the tables of your original Northwind.mdb file. Make a copy of the file in another folder.
To edit (update) the current row, apply the Edit method and then set the new value of each field you want to change. The changes don't become permanent until you apply the Update method. Following is the ...