ACC97: Web Browser Error Opening Subform in ASP File

• Microsoft Access 97

SYMPTOMS

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

When you use Microsoft Internet Explorer to open an ASP file created from a form and a subform in Microsoft Access 97, you may receive the following error message:

   Internet Explorer cannot open the Internet site <URL>. The site was not
   found. Make sure the address is correct, and try again.

If you use a proxy server for your Internet access, you may receive an error similar to the following:

   HTTP Proxy reports: The proxy server has encountered an error (Host was
   not found).

CAUSE

You did not specify a Server URL or you typed an incorrect Server URL when you exported the form to ASP format in Microsoft Access 97.

RESOLUTION

Recreate the ASP files, and specify the full path to the ASP page in the Server URL in the Microsoft Active Server Pages Output Options dialog box, for example, http://myserver/<scripts>, where <scripts> is the name of the folder in which the ASP files exist.

MORE INFORMATION

When you export forms to ASP format, Microsoft Access creates several files. The Server URL information is included in the ASP script files that are generated in order to reference the correct path to the subform. The Server URL is the location where the ASP files are stored on your Web server. For example, if you store the ASP files in the \ASPsamp folder on the \\PubTest server, http://pubtest/aspsamp/ is your Server URL. If you do not enter a Server URL when you create the ASP files, your Web browser will be unable to locate and open the subform.

Steps to Reproduce Behavior

1. Create a System DSN on your Web server that points to the Northwind sample database. For more information about 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
   
   

2. Start Microsoft Access 97 and open the sample database Northwind.mdb.

3. Select the Orders form in the Database window, and on the File menu, click Save As/Export.

4. In the Save As dialog box, click "To an External File or Database," and then click OK.

5. In the "Save Form 'Orders' In" dialog box, select Microsoft Active Server Pages (*.asp) in the Save As Type box, and type Orders.asp in the File Name Box. Select a folder to store the ASP files, and then click Export.

6. In the Microsoft Active Server Pages Output Options dialog box, type the name of the System DSN you created in step 1 in the Data Source Name box, and delete any information in the Server URL box. Click OK.

7. Copy the files you just created -- Orders.asp, Orders Subform.asp, and Ordersalx.asp -- to a folder on your Web server where you have Execute permission.

8. Start your Web browser and type the URL in the address box to view Orders.asp. For example, if you copied your ASP files to the \InetPub\ASPsamp folder on your Web server, type http://<ServerName>/ASPsamp/Orders.asp.

REFERENCES

For more information about exporting ASP files, search the Help Index for "ASP files," or ask the Microsoft Access 97 Office Assistant.

For more information about configuring Microsoft Internet Information Server (IIS) permissions, please refer to the IIS Help Index, and see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q160754
   TITLE     : ACC97: Error "HTTP/1.0 403 Access Forbidden" Browsing IDC
               Page

   ARTICLE-ID: Q164248
   TITLE     : ACC97: Troubleshooting ASP Forms That Do Not Display in
               Browser

   ARTICLE-ID: Q164008
   TITLE     : ACC97: Subforms Appear Blank When Browsing ASP Files on NT
               4.0

Keywords          : FmsSubf IntAsp IntpWeb kberrmsg kbinterop
Version           : 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb
Solution Type     : Info_Provided