>Thanks for repsonse.
>
>I read the help file but was not sure if Begin/End Transaction, Tableupdate, Rollback would work. In particular I want to be sure data is save, if not tell the user and give them the opertunity to try again or cancel.
>
>This is existing code so I am adding this feature.
As I wrote, the main purpose of transactions is to ensure "all or nothing" is saved, for several tables.
For safety, you should also use FLUSH, to save buffers at the OS-level - and disable the write-cache, if you happen to have one.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)