Offline Access Database Synchronization vs Offline SQL Server Database Synchronization?
Posted on 2011-03-07
Currently, we are using replicas of an Access database so that a number of people can use the database while disconnected from our network. When they come back into the office, they synchronize their copy of the database (with any modifications made) to the master and they also download changes made to the master directly to their replicas or from synchronization from other disconnected users.
We want to look into using a SQL server instead of an Access server. Is it possible to use synchronization with SQL even if the users are disconnected from the network?