ACC97: Error When Clicking Page Link in Report Exported to HTML

ID: Q172287


The information in this article applies to:
  • Microsoft Access 97
  • Microsoft FrontPage 97 for Windows
  • Microsoft FrontPage for Windows, versions 1.0, 1.0a, 1.1, 1.1a


SYMPTOMS

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

When you export a report to HTML format, and then view the report in your Web browser, you may receive one of the following error messages when you click on one of the page links:

HTTP/1.0 500 Server Error (161)

   -or- 
HTTP/1.0 400 Bad Request


CAUSE

You edited a template in Microsoft FrontPage, and then you used that template when you exported the report to HTML.


RESOLUTION

After you have edited the template in Microsoft FrontPage, open it in a text editor, such as Notepad. In the tokens that create the navigation links, replace any instance of the string "%3c" with the character "<"; replace any instance of the string "%3e" with the character ">" as well. For example, change

<a href="%3c!--AccessTemplate_FirstPage--%3e">First</a>
<a href="%3c!--AccessTemplate_PreviousPage--%3e">Previous</a>
<a href="%3c!--AccessTemplate_NextPage--%3e">Next</a>
<a href="%3c!--AccessTemplate_LastPage--%3e">Last</a>

to:
<a href = "<!--AccessTemplate_FirstPage-->">First</a>
<a href = "<!--AccessTemplate_PreviousPage-->">Previous</a>
<a href = "<!--AccessTemplate_NextPage-->">Next</a>
<a href = "<!--AccessTemplate_LastPage-->">Last</a>

After you have saved the edited template, export the report to HTML again.

You can also edit the HTML files to which the report was exported and add the hyperlinks that allow you to move to different pages. For example, on the first page of the exported report, the navigation hyperlinks would be:
<A HREF = "#">First</A>
<A HREF = "#">Previous</A>
<A HREF = "Report1_1Page2.html">Next</A>
<A HREF = "Report1_1Page5.html">Last</A>

However, this method is not recommended because it is inconvenient if the report contains more than a few pages.


STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97. This problem no longer occurs in Microsoft Access 97 Service Release 1.

NOTE: Stand-alone Microsoft Access 97 Service Release 1 is not currently available, but you can update your copy of Microsoft Access 97 to Service Release 1 by downloading Microsoft Office Service Release 1 from Microsoft's Web site at:

http://officeupdate.microsoft.com/Articles/sr1fact.htm


MORE INFORMATION

Steps to Reproduce Problem


  1. Start Microsoft Access and open the sample database Northwind.mdb.


  2. On the Help menu, click Contents And Index and search for "HTML documents, template files," and then display the topic "HTML template file example."


  3. Select all of the text in the topic.


  4. Start a text editor, such as Notepad.


  5. Paste the text from the Help topic into the text file.


  6. Save the file under the name FPTest.htm in the \Templates\Access subfolder of the Microsoft Office folder. The default location of this folder is

    \Program Files\Microsoft Office\Templates\Access


  7. Start Microsoft FrontPage.


  8. On the Tools menu, click Show FrontPage Editor.


  9. Open the file that you saved in step 6.


  10. On the File menu, click Save As. Click As File and save the file as FPTest2.htm.


  11. Quit Microsoft FrontPage and switch to Microsoft Access.


  12. On the File menu, click Save As HTML.


  13. In the first screen of the Publish To The Web Wizard, click Next.


  14. In the screen which asks what you want to publish, click the Reports tab and select Products By Category; then, click Next.


  15. When prompted for an HTML template, click Browse and locate the file FPtest2.htm that you created in step 12. Click Select, and then click Next.


  16. In the next screen, select Static HTML, and then click Next.


  17. When prompted for a location to publish to, choose a directory that has Read access. Click Finish.


  18. In a browser, enter the address of the output file you created in step 17, for example:
    http://<servername>/<directory>/Products by Category_1.html


  19. Click Next to move to the next page. Notice that you receive one of the errors described in the "Symptoms" section.



REFERENCES

For more information about navigation links in templates, please see the following article in the Microsoft Knowledge Base:

Q164007 Reports Exported to HTML Have No Page Links

Keywords : kberrmsg IntpOff IntpWeb HtmView
Version : 97
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: April 23, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.