Updating records in the database with asp net
Microsoft Access offers a variety of options for making updates to records.
Updating the data from a query in MS Access (MDB) may not always be possible.
Future articles will consider cases where more than one table may be involved.
This article uses a table created out of choosing only a few columns from a table in the Northwind database to keep the discussion simple without compromising the concept.
The design view of the table Test Products along with the original table is shown in the next picture. Here have been turned off by setting their values to No.
When you run the form you can change the values in the various columns except the primary key field. You will be able to type the change in the text box; after you have made your edits, you just need to move to another record (movement can be forward or backward).
The Table row shows the name of the table that contains the field.
To see how the values will be changed, look at the expression in the Update To row.
Using the procedure discussed in the tutorial, a Test Product Qry was created using the following SQL View of the Make Table query.
The value that exists before the Update Query is executed is shown in the next picture .
After making entries, when you try to close the query editor, you will be asked whether you want to save and you may give a name to the query.
Queries in the main screen of the access file can be easily identified as they are shown with different types of icons.
You may run the Update Query you created by double clicking its icon.