Microsoft KB Archive/262988

= MOD2000: &quot;Make Deleted Rows Available to Script&quot; Option Not Saved =

Article ID: 262988

Article Last Modified on 7/31/2001

-

APPLIES TO


 * Microsoft Office 2000 Developer Edition

-



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.



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.

Additional query words: data-type modDesigners modWFDesigner pra

Keywords: kbbug kbpending kbworkflowdesigner KB262988

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.