Microsoft KB Archive/219158

= FP2000: Submitting Form Displays Confirmation Page but Does Not Add Data to Database =

Article ID: 219158

Article Last Modified on 10/1/2001

-

APPLIES TO


 * Microsoft FrontPage 2000 Standard Edition

-



This article was previously published under Q219158



SYMPTOMS
After you click Submit in your Web browser on a form that is set to save to a database, you receive a form confirmation page, but no data is added to your database.



CAUSE
The database and form field column values have not been specified. If you do not provide this information, the data will not be added to any database connection you may have in your Web.



RESOLUTION
To resolve this issue, follow these steps:
 * 1) Open the page containing the form in Page view of FrontPage.
 * 2) Right-click the form, and click Form Properties.
 * 3) Click Options.
 * 4) On the Database Results tab, select a database connection to use and the database table to hold the form results.
 * 5) Click the Saved Fields tab.
 * 6) Click each form field, and click Modify. For each form field, select the column to hold the data entered in the form field.
 * 7) Click OK twice.
 * 8) Save the page.



MORE INFORMATION
After you click to select the Send To Database option and click OK, you will receive the following message:

This form will not work correctly since the settings are invalid.

Would you like to edit them now?"

If you click No, not all the necessary information has been specified. Although you receive a form confirmation on the page, the data will not be added to your database.

Additional query words: front page

Keywords: kbbug kbpending KB219158

-

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

© Microsoft Corporation. All rights reserved.