• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 17. Access Replication Made Easy > Using Partial Replication

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 steps:

1.
Within Microsoft Access, with the database that you want to replicate open, select Tools, Replication, Partial Replica Wizard. The Partial Replica Wizard appears.

2.
Designate whether you want to create a new partial replica or modify an existing partial replica (see Figure 17.32). Click Next. The screen appears as in Figure 17.33.

Figure 17.32. The Partial Replica Wizard prompts you to designate a name and location for the partial replica; indicate whether you want to create a global, local, or anonymous replica; and indicate whether you want to designate the replica as read-only or prohibit users from deleting records in the replica.


Figure 17.33. Designate whether you want to create a new partial replica or modify an existing partial replica.


3.
Designate a name and location for the partial replica, and indicate whether you want to create a global, local, or anonymous replica. This step also allows you to designate the replica as read-only or to prohibit users from deleting records in the replica. Designate your options and click Next.

4.
Create a filter expression that limits the data contained in the partial replica. To do this, select the table whose data you want to filter. Next select the field that you want to use as criteria and select the operator appropriate for the expression. Click Paste. To complete the expression, enter for the expression the value that you want to use to limit the data contained in the partial replica. You can expand or refine the selection using And and Or, as appropriate. Figure 17.34 shows a filter expression that creates a partial replica with data only for customers in the region of California. Click Next.

Figure 17.34. Designate the filter expression used to limit the data contained in the partial replica.


5.
The next step of the Partial Replica Wizard is very important. It allows you to designate additional tables that you want to include within the partial replica. Tables that appear bold are related to the table whose criteria you are using to create the partial replica. You must deselect these tables so that only records related to the records in your filter are included in the partial replica. Tables that are not bold are not related to the filtered table with referential integrity enforced. It is up to you whether you want to include the data within these unrelated tables. In Figure 17.35, the check marks have been removed from all the related tables, but the check mark remains for the unrelated table. This means that only related data is included for all the tables in which referential integrity is established, whereas the entire Customers1 table is included.

Figure 17.35. Designate what additional data is included in the partial replica.


6.
Finally, you can designate whether you want Access to create a report with all the property settings that apply to the partial replica. Make your selection and click Finish.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint