Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

In FrontPage 2003 and in FrontPage 2002, a confirmation form appears, but no information is written to the database

View products that this article applies to.


In Microsoft Office FrontPage 2003 and in Microsoft FrontPage 2002, when you submit a form, a confirmation page appears. This gives you the impression that the form was submitted successfully, but no information is written to the database.

↑ Back to the top


This problem occurs if you mark a field in the database as a primary key and then submit a form that duplicates data that was previously submitted in a field marked as the primary key field.

For additional information, see the "More Information" section later in this article.

↑ Back to the top


Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. To work around this problem, follow these steps:
  1. Open the file located in the _fpclass folder.
  2. Locate the FP_DumpError(strErrorUrl, strMsg) function.
  3. Remove the line that resembles the following.
    On Error Resume Next
  4. Remove the line that resembles the following.
  5. Save and close the file.

↑ Back to the top


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

More information

When you define a field as a primary key in Microsoft Access, all records must have a unique entry in that field. If you attempt to enter duplicate data into the field, Access returns an error.

When using the FrontPage 2002 Server Extensions or the FrontPage 2000 Server Extensions, if you attempt to submit a form to a database with duplicate data in a field marked as a primary key, the following error message appears:
Cannot update the database.
In FrontPage 2003 and in FrontPage 2002, the following line is added to the FP_DumpError function in the file:
On Error Resume Next
This line of code is added to the file to improve cross-codepage support. It causes FrontPage to ignore the error that Access returns when a Web page attempts to add a record that contains duplicate primary key data, but it allows the confirmation page to be displayed. The operation appears successful, but Access does not allow the record that contains the duplicate primary key data to be written to the database.

↑ Back to the top

Keywords: KB314440, kbfix, kbbug

↑ Back to the top

Article Info
Article ID : 314440
Revision : 5
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 370