Updating an access database
This builds on the previous section, where we displayed the contents of the table in buttons update the database with data edited in any of the three data-aware components.
You need to be careful to write the SQL strings correctly otherwise you can edit whole columns in the table inadvertently. We copied the whole folder of our Database Demo project, opened the project and saved it as file in form_database_
Is there any way—short of using a complex VBA procedure—to update the price data in the existing table based on the updated prices from the imported table without overwriting any of the other fields in the existing table?
You probably already know that you can use an update query to update the values of fields in a table, but did you know that you can use an update query to update the values in one table with the values from another? If you can join the two tables on some common field or combination of fields, you can use an update query to update a field in one table based on the values found in a second table.
However, should you prefer to use the 64-bit Flow Heater variant without an Office/Access installation, or you need to process Access .
The data in all the other fields in the existing table is still correct.Update queries are the most efficient way to make bulk changes to data; they are much more efficient than using a recordset in a VBA procedure.The Access Adapter in Flow Heater is responsible for the direct connection to data in Microsoft Access databases.This action query will take the Purchase Price values from tbl Albums Updated and copy it into the Purchase Price field in tbl Albums for each record where the two Album ID fields match and the price value in tbl Albums is currently null.When the query is finished, open tbl Albums again—you should see that the Purchase Price field in this table has been updated based on the values in tbl Albums Updated (see Figure 1-18).