Updating existing records in a dataset
You cannot undo the results of an update query, and making a backup helps make sure that you can reverse your changes if you change your mind.
Top of Page If you're comfortable working with SQL, you can also write an UPDATE statement by using SQL view.The process of updating data from one table to another follows these broad steps: The steps in this section assume the use of two similar tables.In this example, the Clients table is located in a database that you just inherited, and it contains more recent data than the Customers table.Dates outside the range April 13, 1810 and September 16, 1989 exceed the size of an Integer field.To accommodate all possible dates, set the Field Size property of your Number field to Long Integer or greater.
Search for updating existing records in a dataset:
the UPDATE statement is especially useful when you want to change many records or when the records that you want to change are in multiple tables.