It won't matter how you setup transactions as VFP is not supported directly by the DTC. You have a couple of choices --
- Manage the transactions yourself in the data components
- Create a Compensating Resource Manager for VFP that can work with the DTC.
Option 1 is probably the easiest.
>
>Sorry for the delay in responding. I have been putting out a few brushfires. The Backend database for the testing period is VFP 7.0 SP1.
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer