HOW TO: Send Feedback Form Results to a FrontPage 2000-Generated Database (301551)

SUMMARY

This article describes how to create a form and submit form results to a Microsoft FrontPage-generated database.

In FrontPage, you can create a form and then save form results to a database. When a visitor to your Web site fills out and submits the form, FrontPage enters the data directly into the database. If you do not have a database in which to store form results, FrontPage can create a new Microsoft Access database for you. FrontPage uses the fields that you have defined on your form as the columns for the table.

NOTE: You must have the following Microsoft products installed on your computer to complete the steps described in this article:

• Microsoft FrontPage 2000
• Microsoft Access 2000
• Microsoft Personal Web Server (PWS) or Microsoft Internet Information Services (IIS)
• FrontPage Server Extensions

back to the top

Create a Form that Submits Results to a FrontPage Generated Database

To create a form that submits results to a FrontPage-generated database, follow these steps:

1. Start FrontPage, and then open your server-based Web.
2. Open the page on which you want to insert the form.
   
   -or-
   
   On the File menu, point to New, and then click Page to create a new page. In the New dialog box, click Normal Page, and then click OK.
3. On the Insert menu, point to Form, and then click Form.
4. Position the pointer in the form, and then press ENTER several times to create space for adding text and text boxes to your form.
5. Place your pointer in the location that you want on the form, and then type First Name.
6. On the Insert menu, point to Form, and then click One-Line Text Box.
7. Press ENTER to create a new line.
8. Type Last Name, point to Form on the Insert menu, and then click One-Line Text Box.
9. Right-click anywhere on the form, and then click Form Properties.
10. Click Send to database, and then click Options.
11. In the Options for Saving Results to Database dialog box, click Create Database.
    
    After FrontPage has finished creating the Access database for you, you receive a confirmation message similar to the following:

    FrontPage has successfully created a database for you.
    The database can be found at "/fpdb/database_name.mdb.
    When using the Database Results Wizard, use the data connection "database_name.mdb".

12. Click OK to the message, and then click OK to close the dialog boxes.
13. On the File menu, click Save, type a name for your form page, and then click Save.
    
    If the extension of the current page is .htm, FrontPage prompts you to rename the file with the .asp extension for the file to work correctly.
    
    Note that FrontPage also creates a Global.asa file that connects your Web to the database.
14. Under Folder List, click the form page that you created, and then click Preview in Browser on the File menu.
15. Test your form. Type your first name and last name in the First Name and Last Name boxes, and then click Submit.
    
    A Form Confirmation page is displayed in your browser, which displays the results of your submission.

back to the top