| 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 |
About 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
Server-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
Static 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