Microsoft KB Archive/164108

= ACC97: Using Backslashes in Publish to Web Wizard Causes Error =

Article ID: 164108

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q164108



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you open and move through a form that has been exported as a Microsoft Active Server Page (ASP) to a Microsoft Internet Information Server (IIS) using the "Publish to the Web" Wizard, you may receive the following error message:

HTTP/1.0 403 Access Forbidden (Execute Access Denied - This Virtual directory does not allow objects to be executed.

NOTE: This error also occurs when you use Microsoft Personal Web Server on a computer running Windows 95.



CAUSE
The Server URL address you specified, under Microsoft Active Server Pages Output Options in the "Publish to the Web" Wizard, contains backslashes (\\) instead of forward slashes (//). For example, the address was typed as follows:

  http:\\MyServer\Scripts for the Server URL address.



RESOLUTION
Use forward slashes (//) when you type in the server URL address. For example, if your IIS Server address is Northwind, type the following:

http://Northwind/Scripts



STATUS
This behavior is by design.



MORE INFORMATION
NOTE: To recreate the following steps, you must create a System DSN (Data Source Name) on the server that points to the Northwind database.


 * 1) Open the sample database Northwind.mdb in Microsoft Access 97.
 * 2) On the File menu, click Save As HTML.
 * 3) When the "Publish to the Web" wizard starts, click Next.
 * 4) On the "What do you want to Publish?" screen, click the Forms tab, and click to select the Customers check box. Click Next twice.
 * 5) In the "What default type do you want to create?" dialog box, select "Dynamic ASP (Microsoft Access Server Pages)," and then click Next.
 * 6) In the Data Source Name box, type the name of a System DSN that points to the Northwind database.

For information on creating a System DSN, please see the following article in the Microsoft Knowledge Base:

159682 ACC97: "Data Source Name Not Found" Err Msg Opening Web Page
 * 1) In the Server URL box, type the path to your server address using backslashes, for example: http:\\www.myservername\scripts. Click Finish.

NOTE: When you are exporting to ASP file format, you must enter the server URL of the location where the ASP file will be stored on the Web server.
 * 1) Start Microsoft Internet Explorer 3.0 on another computer and type the URL for Customers.asp in the address box. The page should open without any errors.
 * 2) Try to use any of the buttons at the bottom of the form to move through the page. Note that you receive the error message mentioned in "Symptoms" section.

