MOD2000: Missing References Error Message When You Re-create Offline Publication (247522)


The information in this article applies to:

  • Microsoft Office 2000 Developer
This article was previously published under Q247522

SYMPTOMS

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

Error:

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

object

The following is a list of the missing references:

object

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.

CAUSE

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.

RESOLUTION

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.

STATUS

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

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:8/6/2002
Keywords:kbbug kbWorkFlowDesigner KB247522
©2002 Microsoft Corporation. All rights reserved.