FrontPage 2000 Form Results Do Not Save to Access Database

Article translations Article translations
Article ID: 236809 - View products that this article applies to.
This article was previously published under Q236809
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

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.

Properties

Article ID: 236809 - Last Review: February 21, 2014 - Revision: 1.1
APPLIES TO
  • Microsoft FrontPage 2000 Server Extensions
Keywords: 
kbnosurvey kbarchive kbprb KB236809

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com