>James,
>
>This doesn't make sense to me. Whether you use the VFP ODBC Driver or Native VFP the data engine is the same, and it runs on the work statation, so wouldn't network traffic be the same? Have you tested this with a netowrk sniffer?
>
It actually makes sense to me, becuase in a traditional enviorment where files are opened etc, the entire index files have to move from the 'server' to the client work station, moving these larger index files, the first time, can take quite a while,and bog down the network.
With odbc, all you are actually sending over the network is the sql statment, and all you get back is the result... the index and database files, which are stored on the server, never get actually moved to the client workstation.
Bob Lee
In the beginning, there was a command prompt, and all was well.