>As Craig pointed out - if you need Tx's - then it is important. However, MTS provides more than just Tx support. There is the whole security model, just in time activation, connection pooling, etc...

Currently, the VFP DLL only queries the tables. So, I guess the Tx's would not have help me out even if I had them on a SQL server. I am interested in MTS for the resource pooling. I appreciate everyone's feedback!