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

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

Re-create 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, specify 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:
   
   Q159682 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 that 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:

Q160754 ACC97: Error "HTTP/1.0 403 Access Forbidden" Browsing IDC Page

For more information about troubleshooting problems with ASP forms, please see the following articles in the Microsoft Knowledge Base:

Q164248 ACC97: Troubleshooting ASP Forms That Do Not Display in Browser

Q164008 ACC97: Subforms Appear Blank When Browsing ASP Files on NT 4.0

Keywords          : kberrmsg kbinterop FmsSubf IntpWeb IntAsp 
Version           : 97
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: April 16, 1999