>Hi,
>
>'Begin Transaction' is that only apply to one table at a time?
In addition to Jim's reply: only tables that are part of a database can participate in a transaction.
Transactions are used to save changes to several tables on a "all or nothing" basis. If the save to the second table fails, the changes to the first table - even changes saved with TableUpdate() - can be undone.
HTH, Hilmar.
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)