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

Article translations Article translations
Article ID: 243842 - View products that this article applies to.
This article was previously published under Q243842
Expand all | Collapse all

SUMMARY

This article explains how to create a Data Access Page that is linked to an Access database in a Microsoft FrontPage Web.

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.

Properties

Article ID: 243842 - Last Review: September 28, 2004 - Revision: 2.1
APPLIES TO
  • Microsoft FrontPage 2000 Standard Edition
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbinfo kbdatabase kbconfig kbwizard KB243842

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com