Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Choosing the right type of Web page to work with
 
Applies to
Microsoft Access 2000

Using Access, you can create three types of Web pages: data access pages, server-generated HTML files, and static HTML files. Each Web page has unique features and advantages to consider before choosing the one that best meets the needs of your application. This article answers some of the most frequently asked questions about these Web pages.

Comparing the three types of Web pages

The following table summarizes the key information you need to know to make the right choice about which Web page best meets the needs of your application. More detailed information is available on subsequent pages of the article.

Data access page Server-generated HTML Static HTML
Description A Web page connected to an Access or SQL Server™ database, or Microsoft Data Engine (MSDE) A Web page connected to a database through Open Database Connectivity (ODBC) A Web page not connected to a database
Uses Data entry and data analysis Viewing tabular data Reporting data and viewing tabular data
Data access Live, read/write Live, read-only Static, read-only
Where to use Intranet Intranet and Internet Intranet and Internet
Creating Design like other database objects Export to ASP or IDC/HTX format Export to HTML format
Publishing Save to a Web server Requires many steps Save to a Web server
Browsing Works well in a client/server environment Requires processing on a server before viewing Standard HTML behavior
Client software needed Microsoft Internet Explorer 5 or later and a Microsoft Office 2000 license Any browser Any browser that supports HTML 3.2 or later
Server software needed N/A Microsoft Windows® and Microsoft Internet Information Server (IIS) or Personal Web Server N/A

ShowAbout data access pages

What are they?

A new database object in Access 2000, the data access page is a Web page that connects to an Access, Microsoft SQL Server™, or Microsoft Data Engine (MSDE) database. A page can contain ActiveX® controls including a PivotTable® list, a chart, and a spreadsheet.

What do I use them for?

There are many ways to use pages. In general, you use pages to view, edit, update, delete, filter, group, and sort live data. You use grouped pages to report and review large amounts of related data. You use a PivotTable list to analyze data, a chart to visually compare patterns and trends, and a spreadsheet to make calculations.

When do I use them?

Use pages on an intranet where your organization widely deploys Microsoft Office 2000.

How do I create them?

There are several ways to create a page. You can use the Page Wizard, you can edit an existing HTML file, or you can create a page from scratch in Design view just like other Access objects.

How do I publish them?

To make your pages available on the World Wide Web, you save the pages to Web Folders or a Web server, and then make the database available to users of the page by storing it on a public server or folder.

What happens when I use them in a Web browser?

Internet Explorer needs to download the page only once from the Web server to let you view and interact with the data on the page. Because a page uses Dynamic HTML, access to the database is generally very efficient in a client/server environment.

What software do I need to use them?

Pages require Microsoft Internet Explorer 5 or later as the client browser and a Microsoft Office 2000 license. If your pages use three-tier data access, then you must use Microsoft Windows NT® and Microsoft Internet Information Server (IIS) on the server.

Where can I get more information about them?

For more information about pages, see the following Access 2000 Help topics:

  • Strategies for creating data access pages
  • Create a data access page
  • Publish a data access page to Web Folders or any Web server
  • About Web page client/server products and platforms
  • About protecting a data access page

And the following Office Online articles:

  • Ways to report data in Access
  • Show a different image per record on a data access page in Access
  • Creating a grouped data access Page in Access

ShowServer-generated HTML files

What are they?

Server-generated HTML files are Web pages that display live, read-only data in a datasheet format. They are connected to an Access or Microsoft SQL Server™ database through ODBC. Server-generated HTML files can be either Active Server Pages (ASP) files or IDC/HTX files and are processed by Internet Information Server (IIS) to dynamically create HTML files.

What do I use them for?

Use server-generated HTML files when your data changes frequently, you need to see live data in a tabular format, but you only need to see read-only data.

When do I use them?

Use server-generated HTML files for viewing live data on an intranet or on the Internet.

How do I create them?

You create server-generated HTML files by exporting a table, query, or form to Microsoft Active Server Pages (*.asp) or Microsoft IIS 1-2 (*.htx; *.idc) file format.

How do I publish them?

Making your server-generated HTML files available on the World Wide Web requires several steps. For more information, see the Access Help topic: Publish server-generated HTML files to a Web server.

What happens when I use them in a Web browser?

Each time a user opens or refreshes an ASP or HTX/IDC file through a Web browser, the Web server dynamically creates an HTML file, and then sends that HTML file to the Web browser.

What software do I need to use them?

Pages can use any Web browser on the client, but require IIS or Personal Web Server and a Microsoft Windows® operating system on the server.

Where can I get more information about them?

For more information about server-generated HTML files, see the following Access 2000 Help topics:

  • Export a datasheet to server-generated HTML format
  • Publish server-generated HTML files to a Web server
  • How your Web server processes server-generated HTML format
  • About Web page client/server products and platforms

And the following article on the Microsoft Office Developer Web site:

  • Use Access 97 to access live data on the Web

ShowStatic HTML files

What are they?

Static HTML files are the simplest type of Web page Access creates, because they are not connected to a database. They are either reports displayed in a report format, or tables, queries, and forms displayed in a datasheet format. You cannot update the data in a static HTML file.

What do I use them for?

Use static HTML files when you want to report data or display data in a tabular format that does not change frequently.

When do I use them?

Use static HTML files on an intranet or on the Internet.

How do I create them?

You create static HTML files by exporting tables, queries, forms, or reports to HTML Documents (*.html; *.htm) file format.

How do I publish them?

To make your static HTML files available on the World Wide Web, you save the files to Web Folders or copy them to a Web server.

What happens when I use them in a Web browser?

When you access the data through a Web browser, the browser only needs to download the static HTML file once from the Web server to let you view the data. However, the resulting HTML files are a snapshot of the data at the time you published your files. There is no data source connected to the static HTML file, and if your data changes, you won't see these changes until you export your files again and view the new data in a Web browser.

What software do I need to use them?

Static HTML files can use any Web browser that supports HTML version 3.2 or later on the client, and can use any software on the Web server.

Where can I get more information about them?

For more information about server-generated HTML files, see the following Access 2000 Help topics:

  • Export a datasheet to static HTML format
  • Export a report to static HTML format
  • Publish static HTML files to Web Folders or any Web server
  • About Web page client/server products and platforms

And the following article on the Microsoft Office Developer Web site:

  • Using Access 97 to share static data on the Web
Get Office 2007
Get Office 2007
advertisement