A laptop user virtually always has a
complete copy of the database on their computer and makes changes directly
to the mobile database. Later on, these changes have to be synchronized with
the stationary database located on the company??™s network.
A frequently requested feature in Microsoft Access is an easy way to synchronize
data changes among multiple copies of the same database. Many developers
have implemented complex??”and often inefficient??”schemes
whereby data are exchanged between Access database files. With very few
exceptions, these schemes fail to take into account all the issues involved
with data synchronization, such as resolving the conflict that occurs when
multiple users change the same record between synchronization events.
Which record (roving or stationary) should win and be updated on the network?
There is no easy way to establish rules that accommodate all contingencies
in a home-grown replication scheme.
987
IN THIS CHAPTER
Understanding database
replication
Creating a replication Design
Master
Creating replica databases
Synchronizing data between
replicas
Synchronizing design changes
between replicas
Studying VBA code to perform
replication operations
Using the Access
Replication Features
There are many other problems with such schemes.
Pages:
1828
1829
1830
1831
1832
1833
1834
1835
1836
1837
1838
1839
1840
1841
1842
1843
1844
1845
1846
1847
1848
1849
1850
1851
1852