Microsoft KB Archive/280378

= ACC2000: Initial Synchronization Is Bidirectional with Internet or Indirect Synchronization =

Article ID: 280378

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q280378



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 &quot;message-based&quot; 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.



RESOLUTION
To enforce a strict, one-way exchange of user data at all times, you must use direct synchronization.



STATUS
This behavior is by design.



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 &quot;http://MyServer&quot;, 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.

Additional query words: prb

Keywords: kbprb KB280378

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.