How to Connect an HTML Page to a Microsoft Access Database

Dynamic content is the primary thing to present organizational information over internet. As far as MS Access is concerned, one can make available information dynamic using various features. One of these features is Data Access Page.

Basically, Data Access Repair Page is an HTML page embedded with Office Web Component that contains connection information regarding a data source. Using Data Access Page, an HTML Page can be easily connected to the tables in an Access database. To do so you will first need to create a new blank database. After that you can create a Data Access Page and link the database to the HTML page. Once database is created, you can create a Data Access Page by using the below mentioned methods.

Creating Data Access Page

Method 1: Creating the Data Access Page by Using the Wizard
To create the data access page by using the wizard, follow these steps:
Start Microsoft Access. Under Objects, click Pages. Double-click Create data access page by using wizard. The Page Wizard dialog box appears.
Verify that the “Contacts” table is selected in the Tables/Queries list box. Click the double chevron button (>>) to copy all the fields into the Selected Fields list box. Select ContactID, and then click the single chevron (<) to cancel the selection of this field. Click Next.
The second page of the wizard allows you to organize your data into groups, such as organizing contacts by country. To keep the design simple, click Next. The third page asks for the sort order of the records. Click Next.
The final page asks for the title of the HTML page and allows you to apply a theme to the HTML page. Click Open the Page, and then click Finish. The data access page is now created and displayed.
Use the record navigation bar at the bottom of the data access page to move through the records and to create two more contacts.
On the File menu, click Save. Save the data access page as “Contacts.htm” in the My Documents folder.
Read the message that appears, and then click OK. Close the data access page.
Method 2: Creating the Data Access Page by Using an Existing HTML Page
To create the data access page by using an existing HTML page, follow these steps:
Start Notepad, and then type the following HTML:

Looking at Excel Web Components to create a DAP

Save the file as MyHTML.htm in your My Documents folder.
In Windows Explorer, double-click MyHTML.htm. The HTML page appears in Microsoft Internet Explorer. Quit Internet Explorer.
Creating Data Access Page Link
To create the data access page link, follow these steps:
Start Microsoft Access. Under Objects, click Pages. Double-click Edit Web page that already exists. The Locate Web Page dialog box appears. Click MyHTML.htm in the My Documents folder, and then click Open. The HTML page opens in Design view.
Click at the end of the line “Looking at Excel Web Components to create a DAP”, and then press ENTER to create a new paragraph.
Create a hyperlink to the Contacts HTML page by following these steps:
On the Insert menu, click Hyperlink. The Insert Hyperlink dialog box appears.
In the Text to display text field, type Click here to view Contacts HTML Page.
Click the HTML file Contacts.htm in the My Documents folder.
Click OK to return to the data access page.
Click at the end of the newly inserted text, and then press ENTER to create a new line on the data access page.
Following above mentioned steps and procedures, you can connect an HTML page without facing any problem.
Use Access Database Repair software to repair the damaged .mdb file. The software supports all versions of MS Access Database starting from MS Access 95.

Search