DOH, the ODBC source defaulted to named pipes, changed it TCP/IP and got the load time down from 88 minutes to 18 minutes... Gonna tweak the temp file settings as you suggested and go from there. Good idea on the temp file location, the system partition is the C drive, default for VFP temp file. It only has about 1 gig free, whereas the D partition has 9 gig free.

>Just a thought -- I ran into a similar problem when I started using nt workstation, it turned out that VFP was at fault -- Namely, the temp files were on the C drive and the application was running on the D drive and doing some local processing to that drive.
>
>Check some other things between the server setup of VFP and the workstation set up, there may be other things that are effecting your result, like buffer sizes, packet sizes, and so forth that you can modify under tools-options.
>
>Good luck!