Troubleshoot HTML formatted files

Microsoft Office Access 2003

When you export a datasheet to ASP or IDC/HTX output format, the data that you see when you display the file in a Web browser is the actual data in the recordset behind the datasheet. By default, Microsoft Access saves Text and Memo fields with left alignment and saves all other supported data types with right alignment.

When you export a datasheet, Access does not output OLE objects or the related values from a Lookup field, and ignores the OrderBy, Filter, Format, and InputMask property settings.

If you want the server-generated HTML files to look like the datasheet in an Access database, you can create and export a query that has the same recordset as the datasheet. When you create the query, do the following:

  • Use the Sort cell in the query design grid to sort the data.
  • Use the Criteria cell in the query design grid to filter the data.
  • Use the Format function to format the fields, such as Currency, Date/Time, and Yes/No.
  • Create an Autolookup query to display the values from a Lookup list.

ShowI can't open a file on the Internet.

The file may no longer be available. Check with the Web site administrator for the status of the file.

You may not have the correct permissions to access the file. Check with the Web site administrator to determine the permissions needed to access the file.

You must have access to the Internet— for example, you could have a modem and an Internet service provider, or you could have access through your corporation's network— to open files at an FTP site or on the World Wide Web.

If you have Internet access and you still can't open the file, the site may be too busy. Try to open the file later.

ShowI want to open an HTML file in Access, but it opens in another Office program

In the Open dialog box (File menu), when you select an Hypertext Markup Language (HTML) file (also called a Web page) and click Open or double-click the file, the file opens in the program that created the file. For example, if you attempt to open an HTML format file that was created in Microsoft Word, the file opens in Word— not in Microsoft Access as a data access page.

  1. To open an HTML file that was created in another Office program as a data access page in Access, do one of the following:

In Windows 2000:

  • Right-click the file in the Open dialog box, point to Open with, and then click Microsoft Access on the shortcut menu.

    Note  If the file type that you are trying to open hasn't previously been associated with another program, instead of pointing to the Open with dialog, click the Open with dialog, and select Microsoft Access from the list of programs.

ShowSupported Web page software

The following table summarizes supported products, platforms, and Web page output format files.

Web page output file format Supported product and platform
data access pages (*.htm, *.html) Dynamic HTML 4.0 or later

Microsoft Internet Explorer 5.01 with Service Pack 2 (SP2) or later

All Web server products and platforms

Server-generated HTML, ASP (*.asp) All Web browsers
  • IIS 5.0 on Windows 2000 Server
Server-generated HTML, IDC/HTX (*.idc, *.htx) All Web browsers
  • IIS 5.0 on Windows 2000 Server
Static HTML (*.htm, *.html) HTML 3.2 or later

All Web browsers

All Web server products and platforms

Note  To use any Web page from a client computer, you need a Web browser, such as Microsoft Internet Explorer, and a connection to the Internet or intranet server where the Web pages are located. For information about how to set up Internet access, see Windows Help.

ShowI get an error message when I try to import or link to data on a FTP or HTTP Server

Microsoft Access does not support importing or linking data from a remote FTP or HTTP server. Save the file or HTML page to your hard drive or intranet site, and then import or link the file from there.