Updating access records in vb6

22-Mar-2018 12:08

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.This is especially true if there are two or more tables involved in the update process.In general data may be updatable, updatable under certain conditions, or not updatable at all.These queries can be created using the query designer tool.Creating an update query using the designer is really very simple. Right click the border between the design and grid to pop open the window with several menu items as shown. The grid changes somewhat, allowing to choose which column or columns you need in the table, and showing you where you can type in the changes as shown.

The data as it exists before the update operation will be displayed in Datasheet view.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.Please read the Microsoft KB article link provided at the conclusion of this tutorial.This tutorial shows various ways you can update the record in a single table.

The data as it exists before the update operation will be displayed in Datasheet view.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.Please read the Microsoft KB article link provided at the conclusion of this tutorial.This tutorial shows various ways you can update the record in a single table.This immediately brings up the message window, letting you know about the changes that are going to be made.