Ooops - thanks for the correction Jim.

>>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
>         * End 2nd txn
>         ENDTRANSACTION
>         * End 1st Txn
>         ENDTRANSACTION
>       ELSE
>         * Rollback 2nd txn
>         ROLLBACK
>         * Rollback 1st Txn
>         ROLLBACK
>       ENDIF
>   ELSE
>     * Rollback 1st txn
>     ROLLBACK
>  ENDIF
>