This example loops through a recordset and asks if the user wants to change the job title of each sales representatives in the Employees table. After the BeginTrans method starts a transaction that isolates all the changes made to the Employees table, the CommitTrans method saves the changes. Later, the Rollback method is used to undo changes that were saved using the Update method.
One or more table pages remain locked while the user decides whether or not to accept the changes. For this reason, this technique isn't recommended, but is shown only as an example.
See How to Build the DAO Method Samples.
If you have installed the DAO SDK, see InstallDirectory\DAOSDK\SAMPLES\BeginTrans.cpp.