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.
Prior knowledge required:
- Database concepts
- Familiarity with Microsoft Access concepts and user interface
Create the Microsoft Access Database
- Start Microsoft Access, and then create a new blank database named "HTMLAccess.mdb".
- Create a new table named "Contacts" by following these steps:
- Under Objects, click Tables.
- Double-click Create table by using wizard. The Table Wizard dialog box appears, and you are asked what types of fields you want to create.
- In the Sample Tables list, click Contacts. Click the single chevron button (>) 10 times to copy the first 10 items from the Sample Fields list into the Fields in my new table list. Click Next.
- Accept the defaults on the second page of the wizard, and then click Next.
- Select the Enter data into the table using a form the wizard creates for me check box, and then click Finish.
- Verify that a new table named "Contacts" has been created. Also verify that a new form named "Contacts" has been created.
- Type information for two contacts in the form (you do not need to type Contact ID values). Use the TAB key to move from one field to the next.
- Click the Close button on the Contacts form. Save the form as Contacts.
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:
<h1>Accessing Data through HTML and Access</h1>
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.
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.
To open the data access page, follow these steps:
- Open Internet Explorer. In the My Documents folder, open the file MyHTML.htm.
- Test all parts of the page.
- Click the hyperlink to verify that it links to the Contacts.htm file.
NOTE: Before you publish this data access page to the Web server, verify that all paths are correct, and change the hyperlinks to URLs.
To change a connection, follow these steps:
- Start Microsoft Access. In the data access page Design view, open the MyHTML.htm file.
- If the Field List is not visible, click Field List on the View menu.
- In the Field List, click the Page connection properties icon that appears under the title bar of the Field List pane. The Data Link Properties dialog box appears.
- Verify that the connection corresponds to the correct path to the database.
- If you scale the database up to Microsoft SQL Server, verify that the OLEDB Provider is correct on the Provider tab.
- Click OK to complete the connection property changes.
To change a URL, follow these steps:
- Select the friendly text for the hyperlink.
- On the Insert menu, click Hyperlink. The Edit Hyperlink dialog box appears.
- Type a URL in the Address box, and then click OK.
Sample data access pages are available in the Northwind database.NOTE
: The Northwind database is installed with a full installation of Microsoft Office XP Professional.
Article ID: 308459 - Last Review: July 1, 2004 - Revision: 3.3
- Microsoft Internet Explorer 5.5
- Microsoft Internet Explorer 5.0
- Microsoft Office XP Professional
- Microsoft Access 2002 Standard Edition
- Microsoft Internet Explorer 6.0, when used with:
- Microsoft Windows XP Home Edition
- Microsoft Windows XP Professional
- Microsoft Windows XP Media Center Edition
- Microsoft Windows XP Tablet PC Edition