ACC97: Query Design Changes Cause Synchronization Error (193208)


The information in this article applies to:

  • Microsoft Access 97
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 <local replica path and file name> and <target server name> is complete, but a problem occurred during synchronization. For more information, open <local replica path and file name>, right click on <target server name> 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 <Query name> 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.

MORE INFORMATION

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.
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbbug kberrmsg kbpending KB193208
©2004 Microsoft Corporation. All rights reserved.