Microsoft KB Archive/244053

= MOD2000: "Cannot Add Columns" Error Adding Workflow to Table Already in Publication =

Article ID: 244053

Article Last Modified on 8/6/2002

-

APPLIES TO


 * Microsoft Office 2000 Developer Edition

-



This article was previously published under Q244053



SYMPTOMS
If an Access Workflow Designer solution already includes a publication and you attempt to add workflow upon a table that is already part of the publication, the following error message appears:

This process cannot continue because of the following error:

Error: (0x80040E14) Cannot add columns to table ' ' because it is being published for merge replication.



CAUSE
The expected behavior of the Access Workflow Designer is not automatically adding new main tables to existing publications. However, new detail and lookup tables are automatically added to publications, including the parent main table.



RESOLUTION
If you need to make schema changes to your solution (including adding a new main table to your solution), first turn off replication (Application Properties, Offline tab, clear the Enable offline replication check box), which drops any existing publications. Then you can recreate the publication.



Steps to Reproduce Behavior

 * 1) Upsize a copy of the sample database Northwind.mdb.
 * 2) After upsizing, start the Access Workflow Designer to register the copy of the Northwind database.
 * 3) Right-click the tables folder, and click Add Main Table.
 * 4) Add Orders as a main table.
 * 5) Select the Orders table and click the Add Workflow Process button (button showing the two arrows).
 * 6) Add workflow to the Orders table. Select Create a new column. You can make up a couple of states to satisfy the wizard.
 * 7) When you have finished creating the new workflow for Orders, create a publication, selecting Orders as the main table.
 * 8) Add Suppliers as a main table.
 * 9) Attempt to create workflow upon the Suppliers main table. Select Create a new column. Once again, enter whatever workflow states you want.
 * 10) After you click Finish in the Workflow Process Wizard, you receive the error message shown in the "Symptoms" section of this article.

Additional query words: prb

Keywords: kbprb kbworkflowdesigner KB244053

-

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

© Microsoft Corporation. All rights reserved.