>Carmen,
>
>1) You *must* use table buffering;
>2) You *must* use TABLEUPDATE()s on each of your tables;
Jim,
The above is not correct. It is not necessary to use buffering for transactions, it is necessary that the tables involved reside in a VFP database.
I would also advise that with two different databases that each one have its own transaction, so that the psuedo code would be;
BEGIN TRANSACTION
Post to database A
IF No Error
BEGIN TRANSACTION
Post to database B
IF No Error
ENDTRANSACTION
ENDTRANSACTION
ELSE
ROLLBACK
ROLLBACK
ENDIF
ELSE
ROLLBACK
ENDIF