Deploying Data Access Pages

You must be concerned with two issues when deploying data access pages. The first issue involves how Access maintains links between the MDB or ADP file and the HTML documents. The second is how the HTML documents link to the appropriate data source. Unfortunately, Access hard-codes both the path from the MDB or ADP file to the HTML document, and the path from the HTML document to the data source. This means problems for you if someone moves the MDB, ADP, HTML documents, or data source.

The first thing that you need to be able to do is determine whether the link to the data access page is broken. The code in Listing 22.1 accomplishes this task.

Listing 22.1. Determining Whether the Link to a Data Access Page Is Broken ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.