Microsoft KB Archive/193208

= ACC97: Query Design Changes Cause Synchronization Error =

Article ID: 193208

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q193208



Advanced: Requires expert coding, interoperability, and multiuser skills.



SYMPTOMS
When you use internet indirect synchronization, you my receive the following error message:

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

-or-

When you use indirect synchronization between two synchronizers, you may receive the following error messages.

On the machine initiating the synchronization:

The requested synchronization between  and is complete, but a problem occurred during synchronization. For more information, open , right click on on the map, and click view synchronization history.

  -and-

In the Replication Design Errors dialog box, Design Error text box on the synchronization target machine:

You don't have the necessary permissions to use the  object. Have your system administrator or the person who created this object establish the appropriate permissions for you.



CAUSE
You may receive these error messages under the following conditions:


 * You have created or modified a replicable query that has the With OwnerAccess Option set to True.

-and-
 * You are using indirect or internet synchronization.

Direct synchronization does not cause this error.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97.



Steps to Reproduce Behavior By Using Indirect Internet Synchronization

 * 1) Create a replica database containing a query that uses the With OwnerAccess Option (Run Permissions = Owner's).
 * 2) Use Replication Manager to manage the replica on an internet/intranet server.
 * 3) Create another replica on a remote computer.
 * 4) From the remote computer, use internet synchronization. The synchronization should be successful.
 * 5) In the Design Master, make a change to the query you created in step 1.
 * 6) Synchronize with the replica managed on the internet server (if that is not the Design Master).
 * 7) From the remote computer, use internet synchronization. The synchronization should fail and you should receive the error messages mentioned in the "Symptoms" section.

NOTE: If you synchronize directly using these same replicas, the synchronization succeeds.

Additional query words: pra

Keywords: kbbug kberrmsg kbpending KB193208

-

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

© Microsoft Corporation. All rights reserved.