Manage database content

Before you can create the pages to manage your database content, you must establish a database connection to your record source.

Step 1 — Establish a database connection

1. On the File menu, point to New, and then click Page or Web.
2. In the New Page or Web task pane, under New from Template, click Web Site Templates.
3. Click Database Interface Wizard, and then, in the Specify the location of the new web box, type the URL of your web site.

   Note   If you want the Database Interface Wizard to run in a web site you've opened, click Add to current web.

4. Click OK.

   Microsoft FrontPage creates a new web site on the server where your account is located.

5. In the Database Interface Wizard dialog box, select Use an existing database connection, and then select a database connection from the drop-down list.

6. Click Next.

7. Select the table or view you would like to use for the database connection, and then click Next.

8. If you want to modify a form field, select a value in the Edit form field type list, and then click Modify.

9. Click a different value in the Form field input type list.

   Notes

   • This is the only field you can modify in this dialog box.

   • If you select Option Button as a form field input type, be sure to select a value under Number of options.

10. Click OK, and then click Next.

11. Follow the steps under "Step 2 — Create pages to manage database content" if you want to create a page that enables you to modify database records.

Step 2 — Create pages to manage database content

To create a page that lets you modify database records, do the following.

1. Select Database Editor, clear the Results Page and Submission Form check boxes, and then click Next.

2. Decide whether you want to use a user name and password to make the Database Editor page secure.

   To secure the page

   • Enter information in the Username, Password, and Confirm your password boxes.

   To make the page available to other users

   Important   A username and password are essential to protect against unauthorized access to your database. Only select this option if you are working in a trusted environment.

   • Select Don't protect my Database Editor with a username and password.

3. Click Next.

4. Click Finish.

   Microsoft FrontPage creates:

   • A page titled "Database Editor-record source", with the filename database_editor.asp, which it opens in Page view.
   • If you chose to use a username and password, FrontPage also creates a page titled "Database Editor Login", with the filename login.asp, which it opens it in Page view.
   • A folder called /Data source_interface/record source (if it doesn't already exist) to store the results page in.

5. Click Preview in Browser to view the page.