I have a 400 million row table that I need to query over a WAN.......
I need replication services....
I need integrated security.....
etc....

With respect to queries over a wan and VFP data, the best way I have found to do it is through RPC's.. Bascially, having a VFP server ON the server that has the data, and remotely activating that server. The server in turn opens the data ON the server - no traffic accross the wire. The VFP server in turn, returns the result to the client via ADO recordset or some other mechanism...

How's that...????

>>In many cases, SQL-Server beats the pants off the VFP engine.
>
>And those cases are...?
>:)