>I am just wondering what people are doing with foxpro and MTS?

The same as any other language developer.. making it easy to create n-tier scalable applications. That's mostly what MTS is for.

What you do is create a VFP COM DLL and host it in MTS. Of course that is in broad terms.

Here's a few links that could be useful:
http://www.microsoft.com/msj/0198/mtscom/mtscom.htm
http://www.west-wind.com/presentations/mts/mts.htm
http://msdn.microsoft.com/library/techart/MTSVFP.htm