Sample updating client records
By selecting data first, you can verify that you’re updating the records you want before you actually change any data.
Tip: Back up your database before you run an update query.
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.
In this example, the Clients table is located in a database that you just inherited, and it contains more recent data than the Customers table.
If the port is not specified, the default port is used.
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).
The text can contain any valid Web protocol, including gopher://, telnet://, ftp://, and wais://.
Not allowed when a Number field is part of a relationship.
As you continue, remember that although the data types for each table field do not have to match, they must be compatible.