I guess I should have read your response before sending mine ;-)!
>You can do this using SQL Server, but not ODBC accessing VFP or Access tables. In order to have a client/server system you must have a database server. This means SQL Server, Sybase, Oracle, etc. The difference here is that there is a program actually running on the server that processes your queries and returns the results to the client. If you use ODBC to access VFP data, this is not what happens. The VFP ODBC driver is really just VFP's data engine with an ODBC interface. When you use it, the driver runs on the client. This means you still have to pull more than just the result set over the network.
>
>However, you shouldn't think that VFP will pull an entire table over the wire to return one record. If your query is optimized, VFP can use the index to find the record(s) to return and pull significantly less than the whole table over the network.
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
