So long as your queries are optimized, the whole table won't come over the wire. The problem is that the VFP engine is running on the client, not the server. This isn't really client/server, it's just VFP connecting to it's data via ODBC on a network share. If you want true CS, you'll have to use a true server side DBMS like SQL Server, ORACLE, etc.
>Thanks for the answer. The reason I didn't wanted the second computer from directly accessing the data is to prevent the entire 1 millon records table from going down the network to select just 1 record.
>
>But I thought that it wouldn't be possible with ODBC - after all, MS sells SQL Server! :-)
"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