1004
Professional Database Development Part IV
Although this section describes three different topologies, other arrangements are possible. As you
build your replication scheme, be sure to consider alternatives if it appears the chosen design is too
inefficient or adds too much traffic to the network.
Replication from the
Developer??™s Perspective
Replication presents many interesting and intriguing challenges for you as an Access developer. Not
only do you have to understand how replication works; you have to design a replication scheme
that is best suited for your users and their work flow. Then you have to decide whether to train
users how to use the Access menus, or whether it is better to build a custom routine using VBA and
DAO. No matter which system you design, you have to test and debug it after you build it.
A properly implemented replication scheme can save users thousands of hours a year merging and
updating changes in multiple databases. Because replication eliminates the possibility of transcription
errors, the accuracy of the data contained in multiple databases is ensured.
Pages:
1864
1865
1866
1867
1868
1869
1870
1871
1872
1873
1874
1875
1876
1877
1878
1879
1880
1881
1882
1883
1884
1885
1886
1887
1888