Microsoft KB Archive/287993

= How to use an existing database with the Database Interface Wizard in FrontPage 2002 =

Article ID: 287993

Article Last Modified on 10/28/2004

-

APPLIES TO


 * Microsoft FrontPage 2002 Standard Edition

-



This article was previously published under Q287993





For a Microsoft FrontPage 2003 version of this article, see 825502.

IN THIS TASK

 * SUMMARY
 * Use an Existing Database with the Database Interface Wizard



SUMMARY
This article describes how to use an existing database with the Database Interface Wizard from FrontPage 2002.

This example uses the Northwind sample database that is included with Office XP. The same steps apply to a database that is created automatically by using either FrontPage 2002 or FrontPage 2000.

back to the top

Use an Existing Database with the Database Interface Wizard
If you already have a database in your Web, skip the first six steps.
 * 1) Open a Web in FrontPage 2002.
 * 2) Open a new page, and then click Save As on the File menu.
 * 3) Save this page as Sample.asp.
 * 4) With the insertion point in Sample.asp, point to Database on the Insert menu, and then click Results.
 * 5) In the Database Results Wizard, click Use a sample database connection (Northwind), and then click Next.
 * 6) In step 2 of the wizard, click Cancel.

You now have a folder called FPDB in your Web and a database inside that folder called Fpnwind.mdb. FrontPage automatically created a connection string to use in step 10.
 * 1) On the File menu, point to New, and then click Page or Web. In the task pane, click Web Site Templates under New from template.
 * 2) Click the Database Interface Wizard template.
 * 3) Select the Add to current Web check box, and then click OK.

NOTE: If you do not add this Web to the current Web, you cannot choose the correct database connection name in step 10.
 * 1) When the wizard starts, click Use an existing database connection, and then click Sample in the drop-down list.
 * 2) Click Next three times.
 * 3) Under Database Interface Pages, select the Database Editor, Results Page, and Submission Form check boxes.
 * 4) Click Next, and then choose either to use a password or not to use a password.
 * 5) Click Next and then Finish.

You should have an entire Sample_interface folder in your Web, which includes all of the pages that you need to view, edit, delete, and add to the database.

NOTE: For information about an issue with updating the database if the database was created by using a form in FrontPage 2000 or FrontPage 2002, please see the following Microsoft Knowledge Base article:

287147 FP: Error Message: &quot;Database Results Error&quot; When You Update a Database Record

back to the top

Additional query words: OfficeKBHowTo inf

Keywords: kbhowtomaster kbdatabase kbwizard KB287993

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.