Hi Shlomo
>My question is, do I need to issue 3 Begin Transaction commands (before each process of the appropriate DB) and 3 End Transaction / Rollback, or I need only one at the begining of the process and one at the end.
>I am using VFP 7.
Yes, you will need separate transactions for each database. VFP Transactions are handled in the DBC and you cannot actually span DBCs within the same transaction.
Probably the best solution is to write out the current version of each record that you are going to modify before you do anything so that you can 'roll back' changes in other datbases if one fails.
----
Regards
Andy Kramek