ACC97: Web Browser Error Opening Subform in ASP File

Last reviewed: August 25, 1997
Article ID: Q164002
The information in this article applies to:
  • 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.

Note that you may receive a different error message using another Web browser.

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.

Note that your Web browser returns an error when it tries to open the subform because you did not enter a Server URL in step 6.

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

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

   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


================================================================================


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: August 25, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.