This article describes how to use an existing database with
the Database Interface Wizard in Microsoft Office FrontPage 2003.Note
This example uses the Northwind sample database that is included
with Microsoft Office 2003. The same steps apply to a database that you can
create automatically when you use FrontPage 2003.
Use an Existing Database with the Database Interface Wizard
If you already have a database in your Web, skip the first eight
steps. To use an existing database with the Database Interface Wizard, follow
- Open your Web in FrontPage 2003.
- On the File menu, click
- On the New task pane, click Blank
page to open a new page.
- On the File menu, click Save
As, and then save your new page as
- With the insertion point in your Sample.asp page, point to
Database on the Insert menu, and then click
- In the Database Results Wizard dialog box,
click Use a sample database connection (Northwind), and then
- Click Cancel to cancel the Database
You now have a folder in your Folder
List of your Web that is named FPDB and a database
inside that folder that is named Fpnwind.mdb. FrontPage
automatically created a connection string to use in step 12.
- On the File menu, click
Close to close the Sample.asp page.
- On the File menu, point to
- In the New task pane, under New
Web site, click More Web site templates.
- On the General tab, click Database
Interface Wizard, click to select the Add to current Web
site check box, and then click OK.
Note If you do not add this to the current Web, you cannot select the
correct database connection name in step 12.
- In the Database Interface Wizard, click Use an
existing database connection, click Sample in the
drop-down list, and then click Next.
- Click Next two times.
- Under Select the database interface pages you would
like the wizard to create for you, click to select the Results
Page, the Submission Form, and the Database
Editor check boxes, and then click Next.
- Under Enter a username and password that you will
use to access your database editor, do one of the following and then
- Type a username and password that you will use to
access your database editor.
- Click to select the Don't protect my submission
page or my database editor with a username and password check box if
you do not want to use a username and password.
- Click Finish to complete the Database
You now have a whole Sample_interface
your Folder List of your Web. The Folder List includes all the pages that you
need to view, to edit, tp delete, and to add to the
Article ID: 825502 - Last Review: October 23, 2006 - Revision: 1.5
- Microsoft Office FrontPage 2003
|kbdatabase kbhowtomaster KB825502|