MOD2000: "Unable to Access the Workflow Table" Error When You Edit Records Offline (247792)


The information in this article applies to:

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

SYMPTOMS

You may receive the following error message
Unable to access the workflow table 'sqlstore:/server/[user]..[workflow table name]/'. The table is either missing or unavailable. If you continue to receive this message, contact your team solution owner.
when all of the following conditions are true:
  • You create an offline subscription on the development computer.
  • You create a data access page that has the Workflow Toolbar Control on it.
  • You create the offline subscription on the end-user client computer.
  • You change the password for the sa account on the end-user client computer.

CAUSE

You have changed the password on the end-user client computer and have not synchronized with the online data store.

RESOLUTION

After you change the password for the sa account on the end-user client computers, immediately synchronize with the online data store before you try to take a solution offline. To do this, connect to the page in an online manner and synchronize. That way you are prompted for the new sa password. After you enter the new sa password, the offline publication use of the page will function properly.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. On the development computer, create an offline publication for a workflow-enabled application. Be sure you also have a data access page with the Workflow Toolbar Control for this solution.
  2. On the end-user client computer, browse to the data access page for the solution.
  3. On the end-user client computer, click Offline Workflow Toolbar.
  4. Click Make Available Offline. Click the name of the subscription. This opens the Add Favorite dialog box. Create a favorite for this page, and then click to select the Make Available Offline check box. This starts the synchronization process, which may take some time, depending on the size of the subscription.
  5. After the synchronization is finished, click Work Offline on the File menu in Microsoft Internet Explorer.
  6. Click Refresh.
  7. Click Start, and then click Run.
  8. Type command, and then click OK.
  9. At the command prompt, type osql -Usa -P, and then press ENTER.
  10. At the "1>" prompt, type sp_password NULL, 'new', 'sa'. Press ENTER. This changes the old password, which was blank, to the password new.
  11. At the "2>" prompt, type go. You receive a message that the password was successfully changed.
  12. At the "3>" prompt, type exit. Press ENTER.
  13. At the command prompt, type exit. Press ENTER.
  14. Browse to the data access page. On the File menu in Microsoft Internet Explorer, click Work Offline.
  15. Click Refresh. Be sure to click Stay Offline when you are prompted.
  16. Try to either add a new record or edit an existing record. Click Save Changes. Note that you receive the error message mentioned at the beginning of this article.
Modification Type:MajorLast Reviewed:8/6/2002
Keywords:kbprb kbWorkFlowDesigner KB247792
©2002 Microsoft Corporation. All rights reserved.