This topic provides reference information about:
You create a data access pages as a database object that contains a shortcut to the location of the page's corresponding HTML file. Learn about creating data access pages.
Use pages to view, edit, update, delete, filter, group, and sort live data from either a Microsoft Access database or a Microsoft SQL Server database, in Microsoft Internet Explorer 5 or later. A page can also contain additional controls called including a spreadsheet, a PivotTable list, and a chart.
To make your pages available on the World Wide Web, you publish the pages to Web Folders or a Web server, and make the Access database or SQL Server database available to users of the page.
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.
Return to top
You can create server-generated HTML files, either ASP or IDC/HTX, from tables, queries, and forms. Server-generated HTML files are displayed in a table format in a Web browser. Use server-generated HTML files when you want to use any Web browser, your data changes frequently, you need to see live data in a table connected to an ODBC data source, but you only need to see read-only data.
Once you output ASP or IDC/HTX files, you must publish these files to be processed on a supported Web server product and platform.
Each time a user opens or refreshes an ASP or HTX file from a Web browser, the Web server dynamically creates an HTML file, and then sends that HTML file to the Web browser.
Return to top
You can create static HTML files from tables, queries, forms, and reports. In a Web browser, reports display in a report format, and tables, queries, and forms display in a datasheet format. Use static HTML files when you want to use any Web browser that supports HTML version 3.2 or later and your data does not change frequently.
To make your static HTML files available on the World Wide Web, you publish the files to Web Folders or a Web server.
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 ODBC data source connected to the static HTML file, and If your data changes, you must export your files again to be able to view new data in a Web browser.
Return to top