ACC97: Query Design Changes Cause Synchronization Error

ID: Q193208

The information in this article applies to:

Microsoft Access 97

SYMPTOMS

Advanced: Requires expert coding, interoperability, and multi-user skills.

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

Create a replica database containing a query that uses the With OwnerAccess Option (Run Permissions = Owner's).

Use Replication Manager to manage the replica on an internet/intranet server.

Create another replica on a remote computer.

From the remote computer, use internet synchronization. The synchronization should be successful.

In the Design Master, make a change to the query you created in step 1.

Synchronize with the replica managed on the internet server (if that is not the Design Master).

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          : kberrmsg kbdta RplGen 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 23, 1999