ACC2000: Initial Synchronization Is Bidirectional with Internet or Indirect Synchronization (280378)

SYMPTOMS

When you perform an initial synchronization of a remote Microsoft Access replica database using Microsoft Jet Replication and you are using either Internet or Indirect synchronization, all data and design changes are sent in both directions, even if the dbRepExportChanges or dbRepImportChanges flag is used.

CAUSE

Internet and indirect synchronization use "message-based" replication. Message-based replication forces an exchange of user data whenever there are pending system table changes in a database. During the initial synchronization, Microsoft Jet replication needs to update system tables in both the remote replica and the hub replica to update the location information of the remote replica, which forces a two-way user data exchange because message-based replication is being used.

MORE INFORMATION

Steps to Reproduce the Behavior

Set up a computer with Internet replication, and then create a hub replica with one user-defined table that contains no records.

Add the following code to a module in the hub replica:

Sub SyncReplica()
   Dim db As Database
   Set db = CurrentDb()
   db.Synchronize "http://MyServer", dbRepSyncInternet + dbRepImportChanges
End Sub

Make a copy of the hub replica on a remote computer, and then add a record to the user-defined table in both the hub replica and the remote replica.
Synchronize the remote replica by running the SyncReplica method that you created in step 2 in the remote replica.

Note that after the replication is complete, you see both records that you added in both the hub replica and the remote replica, even though you used the dbRepImportChanges flags to indicate a one-way exchange of data.