Microsoft KB Archive/236809

= FrontPage 2000 Form Results Do Not Save to Access Database =

Article ID: 236809

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft FrontPage 2000 Server Extensions

-



This article was previously published under Q236809



SYMPTOMS
When you submit form results online in FrontPage 2000, the data in the form fields is not saved to the database and no error message is received.



CAUSE
The form fields are not correctly mapped to the database columns.



RESOLUTION
Use the Form Properties to re-map the forms. To do this, do the following:
 * 1) In FrontPage, open the Web and page on which your Form resides.
 * 2) Right-click inside the form and click Form Properties.
 * 3) Make sure the Send to Database option is enabled.
 * 4) Click Options.
 * 5) On the Options for Saving Results to Database dialog box, click the Saved Fields tab.
 * 6) In the Form Fields to Save area, click to highlight the form field name.
 * 7) Click Modify.
 * 8) In the Modify Field dialog box, make sure the field name corresponds to the correct column name in the database. (You can choose from the list of columns in the drop-down menu.)
 * 9) Click OK twice.
 * 10) Save the page and preview it in the browser.

The data will now be saved to the database when the form is submitted.



WORKAROUND
If not much time and effort was invested in creating the database, let FrontPage create a new database and map the fields and columns for you. To do this, do the following:
 * 1) Create an HTML file in FrontPage.
 * 2) On the Insert menu, point to Form, and click Form.
 * 3) Add any form fields you will need (including Submit Button).
 * 4) Right-Click inside the form and click Form Properties.
 * 5) On the Form Properties dialog box, click the Send to Database radio button.
 * 6) Click Options.
 * 7) In the Options for saving results to database dialog box, click Create Database.
 * 8) Click OK when FrontPage has successfully created the database.
 * 9) Click OK.



MORE INFORMATION
In order for a FrontPage Form to correctly save data to a database, the page's form fields must match the columns of the database in which the form field's data will ultimately be stored.

Additional query words: front page

Keywords: kbprb KB236809

-

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

© Microsoft Corporation. All rights reserved.