MOD2000: "Make Deleted Rows Available to Script" Option Not Saved (262988)


The information in this article applies to:

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

SYMPTOMS

After you click to select the Make deleted rows available to script check box and save the option in the Access Workflow Designer, you find that when you re-open the Access Workflow Designer, the option is no longer selected.

CAUSE

You have added a new column with the data type of Text to your main table.

RESOLUTION

If you need the Make deleted rows available to script option, and you have a column with the data type of Text in your main table, you can do one of the following:
  • Temporarily change the data type of the column to varchar, select the option, and then change the data type back to text.
  • Move the text column to a separate table that has a one-to-one relationship with the main table.

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

NOTE: These steps require a computer that has the Access Workflow Designer Server, Microsoft Office Developer, and Microsoft SQL Server 7.0 installed.
  1. Open the Access project IssueTracking.adp in Access 2000. If the project does not exist, create it by running the New Team Solution Wizard.
  2. On the Tools menu, click Access Workflow Designer.
  3. In the Access Workflow Designer, locate Object List, and then expand Workflow Processes.
  4. Right-click IssuesWorkflow, and then click Properties.
  5. Click the General tab, and make sure the option Make deleted rows available to script is not selected.
  6. Click Save, quit the Access Workflow Designer, and then quit Microsoft Access.
  7. In SQL Server Enterprise manager or Query Analyzer, open the Issue Tracking database, and then add a new column with a data type of Text.
  8. Save the changes and re-open IssueTracking.adp in Access 2000.
  9. On the Tools menu, click Access Workflow Designer.
  10. In the Access Workflow Designer, locate Object List, and expand Workflow Processes.
  11. Right-click IssuesWorkflow, and then click Properties.
  12. On the General tab, click to select the Make deleted rows available to script check box.
  13. Click Save, and then click Close.
  14. Again, right-click IssuesWorkflow, and then click Properties. Note that on the General tab, the Make deleted rows available to script is not selected.
Modification Type:MajorLast Reviewed:7/31/2001
Keywords:kbbug kbWorkFlowDesigner KB262988
©2002 Microsoft Corporation. All rights reserved.