Hello All, I am looking for advice on sharing an Access Database across a WAN.
We have win2k3 servers at two locations on either side of a VPN. These servers are domain controllers for a common domain broken up into two sites. Both sites need to be able to create reports from and make changes to the data in a common Access DB. With the DB stored on one server, working from the other location (across the VPN) is painfully slow. We have implemented a Distributed File System to share other data and is working very well as expected. It would work very well for our database aswell except that whenever any record is changed, the entire file must be transfered to synchronize the copy at either end. This creates an oppertunity for error in that two people at either location could be working with their respective database, and somebody's work will be overwritten.
Now on to my question; is there a utility within Win2k3, or a piece of 3rd party software that will synchronize duplicate access databases by the record in in real time?
Thanks for your advice,