> Tushar, the trouble is that the tmpfiles setting is established very early in VFP's instantiation. After which it cannot be changed. So, if you alter the tmp or temp environment variable inside your VFP app, VFP does not see the change. You could make the change in a wrapper which is fine if you're running the app yourself which generally is not the case for a com app. If you do wrap your com app in a wrapper that sets a new tmpfiles location, running the vfp app will yield a separate process- iow it will be the wrapper rather than your vfp app that is accessible to the calling application via com. I suppose it would be possible to create a com wrapper that changes tmpfiles and then provides passthrough access to everything in your app... I'll think about that.

Yes. Creating a separate process for each instance of the object is a PITA. If the coding is not complicated, do as Brad suggests. Though if you have subqueries etc, I think they are also stored in temp files. So your subqueries will have to created as separate queries too.

Regards
Tushar