Microsoft KB Archive/290487

= MOD2000: modSystem Database Is Deleted When You Remove Microsoft Office 2000 Developer SR-1 =

Article ID: 290487

Article Last Modified on 8/8/2001

-

APPLIES TO


 * Microsoft Office 2000 Developer Edition

-



This article was previously published under Q290487



SYMPTOMS
When you remove all of the Access Workflow Designer components installed by Microsoft Office 2000 Developer version 1.5, the modSystem database is deleted from SQL Server. Also, because the modSystem database is deleted, you lose any workflow templates that you have not yet saved out to template (.tpl) files.

When you remove all of Microsoft Office 2000 Developer version 1.5, the modSystem database is also deleted. The only exception is if the modSystem database has been published.



RESOLUTION
To prevent this behavior from occurring in the future, do one of the following:  Install Microsoft Office 2000 Developer version 1.5 Service Pack 2 (MODUpdate2). After you apply the Service Pack, if and when you decide to remove Access Workflow Designer Server, the modSystem database is detached from SQL Server but not deleted from your system. To download Microsoft Office 2000 Developer version 1.5 Service Pack 2, see the following article in the Microsoft Knowledge Base:

283939 MOD2000: How to Obtain and Install Office 2000 Developer Service Pack 2 (SP-2)

 In the Team Solutions Manager, save the templates to template files. To do so, open the Team Solutions Manager, and then on the Templates tab, click Export to File. This will save your template to a template file (*.tpl). At that point, you can remove the Access Workflow Designer components.



STATUS
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) Install Microsoft SQL Server 7.0 SP-2 on a Microsoft Windows 2000 Server-based computer.
 * 2) Install Microsoft Office 2000 Professional.
 * 3) Make sure that the FrontPage Server Extensions are installed and configured.
 * 4) From the Microsoft Office 2000 Developer SR-1 CD, install Access Workflow Designer Server and the Access Workflow Designer Client.
 * 5) Open SQL Server Enterprise Manager, and then expand the databases list. Note that modSystem is listed there.
 * 6) Close Enterprise Manager.
 * 7) In Windows Explorer, browse to the MSSQL7 folder, and then open the Data folder. The default location is C:\MSSQL7\Data. Note that a Modsystem.mdf file is in the Data folder.
 * 8) In Control Panel, open the Add/Remove Programs tool.
 * 9) In the Add/Remove Programs dialog box, click Microsoft Access Workflow Designer Server.
 * 10) Click Change/Remove.
 * 11) When you are prompted if you are sure that you want to remove the program, click Yes.
 * 12) In the Add/Remove Programs dialog box, click Microsoft Access Workflow Designer Client Runtime.
 * 13) Click Change/Remove.
 * 14) When you are prompted if you are sure that you want to remove the program, click Yes.
 * 15) Open SQL Server Enterprise Manager, and then expand the databases list. Note that modSystem is no longer listed there.
 * 16) Look at the MSSQL7\Data folder that you looked at in step 7.
 * 17) Note that the Modsystem.mdf file is no longer in the Data folder.

