Access table still updating
Tip: You might want to back up your database before you run an update query.
Read this section if you are new to Access or unfamiliar with the concepts behind relational databases.
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. 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.
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.
As you proceed, remember that updating data is not the same process as entering new data.
Search for access table still updating:
As a result, some of the data in the destination fields may be truncated (deleted).