ACC2000: Unable to Create Dynamic Active Server Page (ASP) in Access 2000 (288751)



The information in this article applies to:

  • Microsoft Access 2000

This article was previously published under Q288751
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

In Microsoft Access 2000, you are unable to save tables, queries, or forms as a dynamic Active Server Page (ASP) like you can in Microsoft Access 97.

CAUSE

This behavior occurs because Access 97 uses the Publish to the Web Wizard and the HTML Layout control to create ASP files. The HTML Layout control was released with Microsoft Internet Explorer 3.0 as an ActiveX control. Internet Explorer versions 4.0 and later enable this functionality (and much more) natively in the browser without requiring an additional ActiveX control. Microsoft Office 2000 and Access 2000 include and require Internet Explorer 5.0 or later.

RESOLUTION

To produce interactive ASP pages, you need to write code for the ASP pages. For additional information about writing code for ASP pages and related issues, click the article numbers below to view the articles in the Microsoft Knowledge Base:

240090 FP2000: How to Update Information in a Microsoft Access Database Using FrontPage 2000 and ASP

240200 FP2000: How to Delete a Record from Microsoft Access 2000

235554 FP2000: How to Filter a Database Query by Using a Drop-Down List

232367 FP2000: How to Filter Information From a Database Results Component Based on the NT Logon

206019 FP2000: ASP Web Wizard 2000 for Databases Available for Download

If you do not want to write code to create interactive ASP pages, you can still save to a static HTML page. Another option is to create a data access page.

MORE INFORMATION

In Access 97, you can save a table, query, or form as an ASP from the File menu, by clicking Save as HTML.

For additional information about creating ASP files in Access 97, click the article number below to view the article in the Microsoft Knowledge Base:

159325 ACC97: Server and Browser Requirements for Publish to Web Wizard

For additional information about the HTML Layout Control and Internet Explorer 4.0, refer to this article at the following MSDN Web site:

Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbprb KB288751