ACC97: Canceling Parameter Prompt Stops Publish To Web Wizard

• Microsoft Access 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you export objects with the "Publish to the Web" Wizard, if you cancel or close any dialog boxes or forms that appear, you may receive the following error message:

   The OutputTo action was canceled.

CAUSE

The "Publish to the Web" Wizard does not contain error handling procedures that allow it to continue after you receive run-time error 2501, the error that occurs when the OutputTo action is interrupted.

RESOLUTION

Do not cancel or close any prompts that appear while you are using the "Publish to the Web" Wizard. For example, if an "Enter Parameter Value" dialog box appears, or if a form opens to input criteria for a report, provide the requested values, and then click OK or Continue.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

If you are exporting multiple database objects when the "Publish to the Web" Wizard quits, any objects that the Wizard has exported prior to the event that stops it are created successfully.

Steps to Reproduce Behavior

1. Start Microsoft Access and open the sample database Northwind.mdb.

2. On the File menu, click Save As HTML.

3. Click Next on the opening screen of the "Publish to the Web" Wizard.

4. On the "What do you want to publish?" screen, click the Queries tab, click Select All, and then click Next.

5. Click Next on the "What HTML document do you want to use as a default template?" screen.

6. On the "What default format type do you want to create?" screen, click Static HTML, and then click Next.

7. On the "Where do you want to publish to?" screen, type the path and name of a folder on your computer (such as C:\My Documents) in the "I want to put my Web publication in this folder" box, and then click Finish.

8. When you receive an "Enter Parameter Value" dialog box, click Cancel. Note that you receive the error message, and the wizard quits. Note also that several queries exported successfully to your C:\My Documents folder. They are the queries that were exported before the "Enter Parameter Value" dialog box appeared.

REFERENCES