Microsoft KB Archive/329824

= BUG: Synchronization of an Access Table May Fail with &quot;The Synchronization Failed Because a Design Change Could Not Be Applied to One of the Replicas.&quot; Error Message =

Article ID: 329824

Article Last Modified on 5/9/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition
 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q329824



SYMPTOMS
When you create a table with a validation rule in Design Master, and then you replicate the table, synchronization may fail with the following error message:

Synchronization between replica '' and replica '' failed.

The synchronization failed because a design change could not be applied to one of the replicas.



WORKAROUND
To work around this problem, perform the following:
 * Make sure that all validation rules exist before you create a replica.

-or-


 * Synchronize the table structure and the data before you add the validation rule.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Problem

 * 1) Open the sample database Northwind.mdb.
 * 2) On the Tools menu, select Replication and then click Create Replica.
 * 3) In the This database must be closed before you can create a replica message box, click Yes.
 * 4) Click No so you do not create a backup copy of the database. Click OK to create a replica that is named Replica of Northwind and then click OK.
 * 5) In the Database window, select the Employees table. On the Edit menu, click Copy.
 * 6) On the Edit menu, click Paste.

This makes the copy of the table.
 * 1) In the Paste Table As dialog box, type Test in the Table Name text box and then click OK.
 * 2) In the Database window, right-click the Test table and then select Properties.
 * 3) In the Test Properties dialog box, click to select the Replicable check box. Click OK.
 * 4) On the Tools menu, select Replication, click Synchronize Now, and then click OK.

