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).
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.
Next, update the radio again, this time using a USB flash drive.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.Tip: You might want to back up your database before you run an update query.The section Restrictions on data type conversions lists the ways in which you can and cannot convert data types. 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.