ACC2000: Long File Names Used for Saving Multiple HTML Pages

ID: Q200571

The information in this article applies to:
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and 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:


    5. 
   <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:


    6. 
   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.

Additional query words: prb 


Keywords          : kbinterop kbdta IntpWeb 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 28, 1999