Microsoft KB Archive/247522

From BetaArchive Wiki

Article ID: 247522

Article Last Modified on 8/6/2002


  • Microsoft Office 2000 Developer Edition

This article was previously published under Q247522


When you re-create an offline publication, you may receive the following error message if related database objects have been removed from the publication since it was last created:

Access Workflow Designer


The following objects contain references that are not included in the publication:


The following is a list of the missing references:


It is recommended that you exclude the objects with missing references, or add the missing references before creating the publication. To make these changes, open the publication in the Access Workflow Designer and select the "Database Objects" tab. Then re-create your publication.

To continue generating the publication, click Yes. To exit and return to the Access Workflow Designer, click No.


If you remove related tables when you re-create an offline publication, Microsoft Access Workflow Designer rechecks dependencies among database objects. If the source object for another database object is missing, the dependencies cannot be verified.


Be sure to add the appropriate underlying database objects. If necessary, click the offline publication's Database Objects tab, and click the All database objects in the solution option to add specific database objects. If an underlying database object already appears with a check mark to the left of its name, click to clear the check mark, select the object again to replace the check mark, save the changes, and then re-create the publication.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.


Steps to Reproduce the Behavior

  1. On a computer where the Access Workflow Designer developer components are installed, create a Microsoft Access project (.adp) to the Microsoft SQL Server pubs database.
  2. In Microsoft Access, click the Access Workflow Designer toolbar.
  3. Register pubs as a valid Access Workflow Designer database.
  4. Add employee as a main table.
  5. Add workflow to the solution, designating employee as the main table. Choose whatever workflow states you want.
  6. After the workflow process has been added to the pubs database, create an offline publication with employee as the main table.
  7. After the publication has been created, click the Database Objects tab. Click to clear the check mark from the employeeWorkflow table (the main workflow table).
  8. Click Save on the Database Objects tab.
  9. When you are prompted, choose to re-create the publication. Note that you receive the error message mentioned in the "Symptoms" section.

Additional query words: pra

Keywords: kbbug kbnofix kbworkflowdesigner KB247522