>You could also consider using a remote control solution. You would need 1 pc for every concurrent user you wanted in the application. Then use a product like REACHOUT or PCAnywhere or PROXY to allow users to control the host pcs. I would recommend REACHOUT. This solution works well even on a slow WAN or dial-up. The host PCs need to be P166 or faster. I know of companies who have banks of 30 or more PCs just for remote control connection. There are of course the normal security problems and at the minimum you would have the computers reboot on disconnect.
>

Robert,

Can REACHOUT run over the WAN connection? My client will not like the dial-up option because of the long distance charges!

I thought of trying to develop a 'service / messaging' program to run at each end of the WAN. I would not access a VFP table over the WAN, I would send a request through the 'service program' the request would then get processed at the other end and a small (hopefully) result would be sent back. This would hide the speed of the WAN from the users (they would be using local data). The service program would run in the background or on another PC and keep both copies of the data (local and WAN) in sync. The actual messages sent between the 'service programs' would have to use a small VFP table or ASCII files.

What do you think? Any ideas? Is there already a product out there that I could use to keep two databases in sync?