>>
>>Well, AFAIK replicating data locally for speed is an accepted way to optimize CS systems.....
>
>Sometimes we force VFP on our clients. John is bringing to fact that they want to use SQL.
>
>I disagree with replicating data between VFP & SQL. That's not optimizing, it's only a crutch. I have found that the people who are SQL only are serious about their decission. They have invested alot of capital in equipment, software and licenses. I would try to do what the client wants his way, and allow VFP to manipulate the data my way.
>
>Moreoften the biggest issue for VFP is security, in that there is none. SQL you have some very substancial security. Don't tell me about Encrypting data because that's not security, it's duct tape.

You mean that the only acceptable way to replicate locally is having a LAN SQL Server where the tables we are interested in should be replicated?

TIA

>__Stephen