Microsoft KB Archive/167851

= ACC97: Canceling Parameter Prompt Stops Publish To Web Wizard =

Article ID: 167851

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q167851



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



SYMPTOMS
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.

After you click OK on this message, the "Publish to the Web" Wizard quits, and no more objects are exported.



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.



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.

