>We are in the process of creating a web interface to our VFP application, but in the meantime we are exploring the possibility of using NT RAS to connect our remote offices. Using this temporary solution, however, takes between an hour and an hour and a half to save a single record and between five to ten minutes to return the results of a basic query. Has anyone delved into this area, is there a way to streamline the operations, or am i heading the wrong way? Any advice would be appreciated.
> Thanks.
>
> -EB
I agree with Josh- this is the wrong approach. Check out Rick Strahl's article on distributed HTTP apps at
www.west-wind.com for some better ideas.
You can also investigate DCOM, which would allow you to build COM servers that live on a server machine and that can serve up data (in string format or in the form of an ADO recordset), to a client program much more efficiently that doing a USE on a table.
Erik Moore
Clientelligence