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

• 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>

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

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>

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://www.microsoft.com/office/office97/servicerelease

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:

   ARTICLE-ID: Q164007
   TITLE     : Reports Exported to HTML Have No Page Links

Keywords          : HtmView IntpOff IntpWeb kberrmsg
Version           : 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbbug
Solution Type     : Info_Provided