I want to be able to run Visual FoxPro programs against data that sits on a server in California. I live and work in Colorado.

The VFP programs typically crunch lots of data. SELECTS or SCANS on 50 MB tables would not be unusual. Appropriate index tags are often in place and are currently helping with the process. At the end of these VFP programs, they may put out extract files or reports.

I want to avoid copying large files. I also want to avoid running from a VFP in client in CO against large data files in CA. Both of these activities are slo-o-w and and tend to choke the WAN.

I've given some thought to a variety of ways for running VFP programs remotely. These are:
1) PCAnywhere.
2) Citrix Server.
3) Moving the data into SQL Server and using client/server technology.
4) Using AT or another Windows NT scheduler to launch a VFP program to run on a remote server.

I don't know all that I'd like to about these various "solutions". There may be even more ways to do it. I hoping for comments on the relative strengths and weaknesses of the different ways to go.