Access table still updating
Changing records manually is not only time consuming, it is also inefficient, and lends itself to errors as you update the records.The best way to handle this type of event, the updating of many records in a database table, is to use an Update Query to make the changes to data in one operation.To add many records to a table at one time, use the INSERT INTO statement along with a SELECT statement.
INSERT INTO statements are commonly referred to as append queries.
To add one record to a table, you must use the field list to define which fields to put the data in, and then you must supply the data itself in a value list. For example, the following statement will insert the values "1", "Kelly", and "Jill" into the Customer ID, Last Name, and First Name fields, respectively.
I'm pretty well up on Access but have never had to link it with another SQL database system.
UPDATE is especially useful when you want to change many records or when the records that you want to change are in multiple tables. The following example increases the Order Amount values by 10 percent and the Freight values by 3 percent for shippers in the United Kingdom: Sub Update X() Dim dbs As Database Dim qdf As Query Def ' Modify this line to include the path to Northwind ' on your computer.
You will save yourself time, and eliminate the possibility of manual errors.