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

• Microsoft Office 2000 Developer

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 '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.

MORE INFORMATION

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 : kbdta modWFDesigner
Version : :
Platform :
Issue type : kbprb