I have a database FE/BE and I need the back end to rest on the server. The problem is the server is in an office in City A and I have three Front Ends in 3 different offices in 3 different towns. I have successfully created a WAN using VPN but even with the VPN it is too slow to be effective. My question is should I replicate the Backend on the server and place the replicas on each workstation? Is this possible to just replicate the backend DB and link to the replica on the workstation so all work is done locally but then on exit can synchronize with the DB Master on the server and then on open can again Sycnch? Is this a sound strategy since the VPN is too slow to directly link to the tables on the server?

Thanks
Michael

I did a basic replication of the backend and copied the replica to the workstation and linked the front end to it and created a command button to synchronize the master and the replica. It works great!

thanks
Michael