BUG: Synchronization of an Access Table May Fail with "The Synchronization Failed Because a Design Change Could Not Be Applied to One of the Replicas." Error Message (329824)


The information in this article applies to:

  • Microsoft Access 2002
  • Microsoft Access 2000
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 '<path/databasename1>' and replica '<path/databasename2>' 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.

MORE INFORMATION

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.
  7. In the Paste Table As dialog box, type Test in the Table Name text box and then click OK.
  8. In the Database window, right-click the Test table and then select Properties.
  9. In the Test Properties dialog box, click to select the Replicable check box. Click OK.
  10. On the Tools menu, select Replication, click Synchronize Now, and then click OK.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

207787 ACC2000: Synchronize with Replicas Before You Change Design Master Schema

Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kberrmsg kbbug KB329824 kbAudDeveloper
©2002 Microsoft Corporation. All rights reserved.