MOD2000: Uninstalling Drops modSystem Database from SQL Server (244315)


The information in this article applies to:

  • Microsoft Office 2000 Developer
This article was previously published under Q244315
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you uninstall the Access Workflow Designer server or developer components, the modSystem database, stored on the Microsoft SQL Server, is dropped.

CAUSE

Application-specific changes should be made to the application-specific database and not to the modSystem database. Therefore, removing the modSystem database is only part of removing the appropriate Access Workflow Designer components and should not impact a team-solution database.

RESOLUTION

If you are making modifications to the modSystem database, back the database up before you remove either the server or developer Access Workflow Designer components. Of course, the best alternative is to make changes to the application-specific database and not to the modSystem database.

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 Behavior

  1. On a computer that has all Access Workflow Designer server prerequisites installed, open Microsoft SQL Server Enterprise Manager.
  2. Open the Databases folder and note that the modSystem database does not exist. Close Microsoft SQL Server Enterprise Manager.
  3. Install the Access Workflow Designer server components.
  4. Open Microsoft SQL Server Enterprise Manager.
  5. Open the Databases folder and note that the modSystem database now exists.
  6. Close Microsoft SQL Server Enterprise Manager.
  7. Click Start, point to Settings, and then click Control Panel.
  8. In Control Panel, double-click Add/Remove Programs.
  9. In the Add/Remove Program Properties dialog box, click the Install/Uninstall tab, and then click Microsoft Access Workflow Designer Server in the program list.
  10. After you have finished removing the Access Workflow Designer server components, open Microsoft SQL Server Enterprise Manager.
  11. Open the Databases folder and note that the modSystem database no longer exists.
Modification Type:MajorLast Reviewed:7/31/2001
Keywords:kbprb kbWorkFlowDesigner KB244315
©2002 Microsoft Corporation. All rights reserved.