Microsoft KB Archive/244218

= MOD2000: Adding Publication During Synchronization Causes Incorrect Conflict Resolution Data =

Article ID: 244218

Article Last Modified on 9/3/2002

-

APPLIES TO


 * Microsoft Office 2000 Developer Edition

-



This article was previously published under Q244218



SYMPTOMS
When you are using Access Workflow Designer, if you attempt to synchronize offline changes when another publication has been added to the solution, you may receive the following conflict error message:

Changes to the online database schema have been detected. This row has not been synchronized and may conflict with a row in the online database. Click "Keep Data Locally" to apply your change.

Also, incorrect data appears in one or more fields shown in the message. If you choose to keep the data locally, the data is saved to your local (offline) data store.



CAUSE
Because solution schema changes occur when you add a publication while synchronizing to a different publication, problems occur when parsing the INSERT statement or statements, and some columns and their related data may not be displayed properly.



RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Developer Service Release 1 (SR-1).

To obtain SR-1, click the article number below to view the article in the Microsoft Knowledge Base:

253566 MOD2000: How to Obtain and Install Microsoft Office 2000 Developer Service Release 1 (SR-1)

To temporarily work around this problem, do not create another publication while attempting to synchronize. If you do create another publication while attempting to synchronize, you will be unable to connect to the online data store and work online until the conflicting data is deleted from the local (offline) data store.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 Developer SR-1.



Steps to Reproduce Behavior
 Install all supporting software on a Microsoft Windows NT Server computer, including the Access Workflow Designer server components. Install the Access Workflow Designer developer components on a Microsoft Windows 98 computer. On the server computer, deploy the Issue Tracking application. On the client computer (running Microsoft Windows 98), start Microsoft Internet Explorer. On the Tools menu, click Internet Options.</li> Click the Security tab.</li> Click Trusted Sites, and then click Sites.</li> Click to clear the Require server verification (https:) for all sites in this zone check box.</li> In the Add this Web site to the zone text box, type the following address

http:// / /default.htm

where  is the name of the server in step 1 and   is the name of the Issue Tracking database that you deployed in step 3.</li> Click OK twice, and then quit Internet Explorer.</li> Start Internet Explorer, and go to the following address

http:// / /default.htm

where  is the name of the server in step 1 and   is the name of the Issue Tracking database that you deployed in step 3.</li> Create an issue and save it.</li> Click Offline, and then click Synchronize.</li> Minimize the Issue Tracking window, and then start Access Workflow Designer.</li> Create another publication named Test in the Issue Tracking database.</li> Wait until both the Test publication and the synchronization are finished.</li> Go back to the Issue Tracking window. On the File menu, click Work Offline.</li> Create one or more issues (offline), and then save them.</li> Click Offline, and then click Synchronize.

Note that you receive the conflict error described in the "Symptoms" section.</li></ol>

Also note the data and the column that the data appears in. Note that the data appears in the wrong column. For example, the date that the issue is due appears in the Subject column.

Additional query words: pra

Keywords: kbbug kbpending kbworkflowdesigner KB244218

-

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

© Microsoft Corporation. All rights reserved.