Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/168869

From BetaArchive Wiki

Article ID: 168869

Article Last Modified on 1/19/2007



APPLIES TO

  • Microsoft Access 97 Standard Edition



This article was previously published under Q168869

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


SYMPTOMS

When you use the "Publish to the Web" Wizard to output a report to HTML format, each page of the report is exported as a separate HTML file that may contain a long file name.

CAUSE

Each page that is output to HTML format will contain additional characters in the file name. These additional characters will sometimes cause the file name to exceed the standard MS-DOS limit of eight characters.

RESOLUTION

If you do not want your file names to exceed the eight-character MS-DOS limit, rename the HTML files, and then modify the HTML source for each file to reflect the new names. The following steps demonstrate how to do this.

NOTE: This section contains information about editing HTML files, and assumes that you are familiar with editing HTML files. Microsoft Access Product Support professionals do not support customization of any HTML, HTX, IDC, or ASP files.

  1. Follow steps 1 through 4 in the "Steps to Reproduce Behavior" section later in this article.
  2. In Windows Explorer, open the folder that contains the HTML files.
  3. Rename each of the HTML files so that it no longer has a long file name.
  4. View the source for the HTML file that was originally named Catalog_1.html, and scroll down to the following lines at the bottom of the source:

    <A HREF="#">First</A> <A HREF="#">Previous</A>
    <A HREF="/?scid=catalog_1page2.html"> Next</A>
    <A HREF="/?scid=catalog_1page9.html">Last</A></BODY>
    </HTML>

  5. Modify the references in the source for Catalog_1Page2.html and Catalog_1Page9.html to reflect the new names you have given these files.
  6. Save and close the renamed Catalog_1.html file.
  7. Open each of the remaining, renamed HTML files and modify the A HREF references for First, Previous, Next, and Last to reflect the new names you have given each of the HTML files.

    You will now be able to use the standard file names on your Web browser.


STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. On the File menu, click Save As HTML.
  3. When the "Publish to the Web Wizard" starts, click Next on the introduction screen.
  4. Click the Reports tab, click to select the Catalog check box, and then click Finish. The wizard will output the following pages:

    Catalog_1.html
    Catalog_1Page2.html
    Catalog_1Page3.html
    Catalog_1Page4.html
    Catalog_1Page5.html
    Catalog_1Page6.html
    Catalog_1Page7.html
    Catalog_1Page8.html
    Catalog_1Page9.html


REFERENCES

For more information about outputting files to HTML, search the Help Index for "HTML documents, outputting object definitions to HTML format," or ask the Microsoft Access 97 Office Assistant.

For more information about modifying file names created with the "Publish to the Web Wizard," please see the following article in the Microsoft Knowledge Base:

163466 ACC97: Publish to the Web Wizard Does Not Allow Custom File Name


Keywords: kbinterop kbprb kbprogramming KB168869