ACC97: Using Backslashes in Publish to Web Wizard Causes Error

• Microsoft Access 97

SYMPTOMS

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

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.

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:

   ARTICLE-ID: Q159682

      TITLE:      ACC97: "Data Source Name Not Found" Err Msg Opening Web Page
   
   

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

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

9. Try to use any of the buttons at the bottom of the form to move through the page. Note that your receive the error message mentioned in "Symptoms" section.

REFERENCES

For more information about using the "Publish to the Web" feature, search the Help index for "Publish to the Web wizard," or ask the Microsoft Access 97 Office Assistant.

Keywords          : IntAsp IntPubWiz OdbcHowto kberrmsg
Version           : 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb
Solution Type     : Info_Provided