Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 243842 - Last Review: September 28, 2004 - Revision: 2.1
How to create a Data Access Page linked to Access database in a FrontPage Web
This article was previously published under Q243842
This article explains how to create a Data Access Page that is linked to an Access database in a Microsoft FrontPage Web.
To create a Data Access Page where the data source is the database in a FrontPage Web, follow these steps:
- Open the FrontPage Web that includes the Access database.
- Double-click the Access database so that it opens in Access 2000.
- In Access 2000, on the File menu, click New.
- In the New dialog box, click Data Access Page and then click OK.
- In the New Data Access Page Wizard, select one of the three wizards for page creation, or select Design view to create your own.
- In the Choose table or query where the object's data comes from box, select the appropriate table or query for your page.
- If you selected a wizard, complete all the steps in the wizard. If Design view was selected, proceed to the next step.
- On the File menu, click Save.
- 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:
- In Internet Explorer, on the Tools menu, click Internet Options.
- In the Internet Options dialog box, click the Security tab.
- 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.
- In the Security Settings dialog box, under the Access Data Sources Across Domains option, click the Prompt button and then click OK.
- Click OK again.
APPLIES TO
- Microsoft FrontPage 2000 Standard Edition
- Microsoft Access 2000 Standard Edition
| kbinfo kbdatabase kbconfig kbwizard KB243842 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate