Row cannot be located for updating some values may have
Note: You cannot run an update query in a Web browser.If you want to run an update query in an Access Web database, you must first open the database by using Access. If you are using an Access web app, you can use data macros to update or change existing data in a set of records.
Tip: You might want to back up your database before you run an update query.This article describes how to create and run an update query in an Access desktop database.You use an update query when you have to update or change existing data in a set of records.You cannot use an update query to add new records to a database, or to delete entire records from a database.To add new records to a database you use an append query, and to delete whole records from a database you use a delete query.The section Restrictions on data type conversions lists the ways in which you can and cannot convert data types.
The table in this section also explains when converting a data type can change or eliminate some or all the data in a field, and what data might be eliminated.
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.
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.
How to back up your database When you need to update data from one table to another, consider the following rule: the data types for the source and destination fields must either match or be compatible.
Furthermore, when you update data from one table to another and use compatible data types instead of matching data types, Access converts the data types of those fields in the destination table.
As a result, some of the data in the destination fields may be truncated (deleted).