Alison Balter's Mastering Access 2002 Enterprise Development

Using Partial Replication

Jet 3.5 and Access 97 introduced partial replication, meaning that you replicate only a subset of the data. This is useful, for example, when you have several salespeople and you want each salesperson to have just his or her own data. However, you want all the salespeople to be able to synchronize their changes with other databases on the network. You can create partial replicas using the Partial Replica Wizard, available via the Access user interface or by using VBA code. The procedure for using VBA code to create a partial replica is covered in the section “Creating a Partial Replica Using Code,” later in this chapter. The text that follows covers the Partial Replica Wizard. To create a partial replica, follow these ...