how to synchronize Access database via the Internet
Posted on 2009-05-11
I would like to synchronize Microsoft Access databases via the Internet (TCP/IP). The Master and Slaves databases look exactly the same. The master database is on a Central Server and the clients are located on different geographically locations. I am planning one-way (one-directional) synchronization with a session to be automatically scheduled and triggered on a weekly basis. this session will be triggered from the Central Server. All servers are using Windows Server 2003.
1- I want to know if this synchronization is possible.
2- if there any product I can get to facilitate this job (third party software). or this is something programmable through VB or Access.
3- is there something I can set up through Windows Server?.