Updating records in access
A Microsoft Access Update Query updates specified values in a table for all records or for those records that match a specified criteria.It is possible to update records manually in a database table, either via a form or through the tables datasheet, however this may take a very long time. To be honest, your query doesn't make much sense, as it says: "update the Quantity to 5 where the Quantity is 5". Refine your query in Access, and once it works, paste it back to the VBA code. If no rows are displayed, that means no row fits your criteria, and nothing will be changed.An Access database is not a file in the same sense as a Microsoft Office Word 2007 document or a Microsoft Office Power Point 2007 slide deck.
Microsoft Office Access 2007 provides a number of tools for updating existing records, including datasheets, forms, queries, find-and-replace, and the new Data Collection feature.
Now consider the following scenario example, that will illustrate the use of a Microsoft Access Update query: One of your product suppliers has decided to increase the price of their products by 3 percent (%) across the board.
You have decided that you will use an Update Query to change all of the relevant records in your Products table.
This displays all the rows from the target table that will be affected by the change.
Before executing it with Run, it is worth taking a look at the affected rows by clicking the View button and selecting Datasheet View.
Search for updating records in access:
Remember these facts about database objects and design as you proceed.