ACC2000: Long File Names Used for Saving Multiple HTML Pages (200571)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q200571
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

When you 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.html, and scroll down to the following lines at the bottom of the source:
       <A HREF="#">First</A> <A HREF="#">Previous</A>
   <A HREF="CatalogPage2.html">Next</A>
   <A HREF="CatalogPage9.html">Last</A>
   </BODY></HTML>
  5. Modify the references in the source for CatalogPage2.html and CatalogPage9.html to reflect the new names that you have given these files.
  6. Save and close the renamed Catalog.html file.
  7. Open each of the remaining, renamed HTML files, and modify the 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.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. Click Reports under Objects, and then select the Catalog report.
  3. On the File menu, click Export.
  4. In the Export Report 'Catalog' To box, click HTML Documents in the Save as type box, and then click Save.
  5. In the HTML Output Options box click OK.

    Note that the wizard outputs the following pages:
       Catalog.html
   CatalogPage2.html
   CatalogPage3.html
   CatalogPage4.html
   CatalogPage5.html
   CatalogPage6.html
   CatalogPage7.html
   CatalogPage8.html
   CatalogPage9.html

REFERENCES

For more information about outputting files to HTML, click Microsoft Access Help on the Help menu, type html in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:11/20/2001
Keywords:kbinterop kbprb KB200571
©2002 Microsoft Corporation. All rights reserved.