A data access page is an HTML page that has an Office Web Component embedded into it. The Office Web Component stores connection information about a data source. This article describes how to use data access pages to connect an HTML page to tables in a database.
Method 1: Create 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: Create 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:
<html> <head> <h1>Accessing Data through HTML and Access</h1> </head> <body> Looking at Excel Web Components to create a DAP </body></hmtl>
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.
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.
To edit and test the data access page, follow these steps:
With the data access page open in Design view, select items from the Field List. If you cannot see the Field List, click Field List on the View menu. In the Field List, expand the Contacts table.
Drag the FirstName and LastName fields onto the data access page, under the last line of text. Two pairs of labels and text boxes will be created, as well as a record navigation bar.
Drag the Contacts table from the Field List onto the data access page, and then drop it after the last text box. The Layout Wizard dialog box appears. Click Office Spreadsheet, and then click OK.
The Relationship Wizard appears. Accept the relationship, and then click OK to return to the data access page. An Office Web Spreadsheet component will be created and displayed.
On the View menu, click Page View to test the page.
Click New on the record navigation bar to clear the First Name and Last Name text boxes. Type a new first name and last name. Click Save on the record navigation bar. The new data will be displayed in the spreadsheet control.
Save and close the data access page. In Microsoft Access, click Tables, and then double-click the Contacts table. Verify that the new data was added to the Contacts table, and then quit Microsoft Access.