Microsoft KB Archive/247522
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:
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
- 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.
- In Microsoft Access, click the Access Workflow Designer toolbar.
- Register pubs as a valid Access Workflow Designer database.
- Add employee as a main table.
- Add workflow to the solution, designating employee as the main table. Choose whatever workflow states you want.
- After the workflow process has been added to the pubs database, create an offline publication with employee as the main table.
- 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).
- Click Save on the Database Objects tab.
- 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