How to create a Data Access Page linked to Access database in a FrontPage Web (243842)

MORE INFORMATION

To create a Data Access Page where the data source is the database in a FrontPage Web, follow these steps:

1. Open the FrontPage Web that includes the Access database.
2. Double-click the Access database so that it opens in Access 2000.
3. In Access 2000, on the File menu, click New.
4. In the New dialog box, click Data Access Page and then click OK.
5. In the New Data Access Page Wizard, select one of the three wizards for page creation, or select Design view to create your own.
6. In the Choose table or query where the object's data comes from box, select the appropriate table or query for your page.
7. If you selected a wizard, complete all the steps in the wizard. If Design view was selected, proceed to the next step.
8. On the File menu, click Save.
9. In the Save Data Access Page dialog box, browse to the location of the FrontPage Web where your Access database is located, and click Save to save the Data Access Page to that location.

NOTE: If you create a Data Access Page while your Access database is still located in the Access default location and then import the database and the Data Access Page into FrontPage, the Data Access Page cannot locate its data source.

When previewing your Data Access Page in a browser, you need to select the Access Data Sources Across Domains option by doing the following:

1. In Internet Explorer, on the Tools menu, click Internet Options.
2. In the Internet Options dialog box, click the Security tab.
3. Click the appropriate security zone (that is, Local Intranet, Internet, Trusted Sites, or Restricted Sites), and then click Custom Level.NOTE: The security zone may vary according to user.
   
   
4. In the Security Settings dialog box, under the Access Data Sources Across Domains option, click the Prompt button and then click OK.
5. Click OK again.