Sending Form Contents to an Access Database Using FrontPage

Often users would like to create an online form that will 'collect' the data by submitting the contents of the form to a database. The following information assumes you've already created an online form and now want to create and connect to a Microsoft Database.

FOLLOW THESE STEPS TO MAKE THE NECESSARY MODIFICATIONS:

1. Open the form you have created, select File, Save As and save the htm document with an asp extension.
   
2. Within the form document, right-click and select "Form Properties"
   
   
   
3. In the Form properties window select "Send to database"; then click on Options. Within this window you will be making changes to each of the three tabs.
   
   On the Database Results tab, click on Create Database... This will create both a folder within your website named 'fpdb' and a Microsoft database.
   
   
   
   Next, select the Saved Fields tab. Remove any fields that you do not want to SEND to the database. For example, you will want to remove the TGorder field.
   
   
   
   Finally, select the Additional Fields tab. These are informative fields that have been added automatically to your database. If you don't want this data collected simply remove the fields. Click OK twice to save and exit these windows.
   
   
   
   NOTE: Even though you may have removed certain fields from 'collecting' data, you will still find that these fields have been added to your *.mdb file. Take one further step and delete the fields from the Access database.
   
   
   
4. Save and Test the form.
5. To view the contents of your database, open the database from the fpdb folder.