I was using the vfp OLE db provider on the client machine.
>

Try with the Vfp OleDB provider. Must be more fast, also becuase the SqlOleDB adapatr can go direc to the oledb provider and not go to the oledb odbc then odbc...