As a best practice, there are two main steps that you must follow to create and run an update query: create a select query that identifies the records that you want to update, and then convert that query to an update query that you can run to update the 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.
The error I'm getting is an EOle Exception "Row cannot be located for updating.
Some values may have changed..." I'm using the follosing connection string: Provider=Microsoft. OLEDB.4.0; Data Source=G:\My Foldert; Extended Properties=DBASE III; I can read the file just fine - just can't post any changes.
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.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.The dates that you can convert depend on the size of the number field.Remember that Access stores all dates as serial dates, and it stores the date values as double-precision floating integers. Dates outside the range April 18, 1899 and September 11, 1900 exceed the size of a Byte field.Note: You cannot run an update query in a Web browser.