Database editor returns an Ox80040E14 error message when you save edited records in FrontPage 2003 (828898)


The information in this article applies to:

  • Microsoft Office FrontPage 2003

SYMPTOMS

When you use the Microsoft FrontPage Database Interface in Microsoft Office FrontPage 2003 to edit records in a database that you created to store the results from a form and you try to save the edited records, you may receive one of the following error messages and the changes are not saved to the database:
Database Results Error Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. Number: -2147217900 (Ox80040E14) Source: Microsoft OLE DB Provider for ODBC Drivers
One or more form fields were empty. You should provide default values for all form fields that are used in the query.
The operation failed. If this continues, please contact your server administrator.

CAUSE

This problem may occur if you use Form Properties to create the database in FrontPage 2003. Databases that are created through the properties of forms in Microsoft FrontPage cannot be used directly with the Database Interface Wizard in FrontPage 2003. This issue occurs because the Timestamp field is a Microsoft SQL data-type and must be enclosed in brackets if used as a column name in a database query. When a database is created in FrontPage 2003, a field that is named Timestamp is included. You do not have the option to remove the Timestamp field when the database is created. You receive an error message when the Update query in the Database Editor is run, because Timestamp is a reserved numeric type in SQL.

WORKAROUND

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, change the page code that is produced by the Database Interface Wizard so that it works correctly. To do this, follow these steps:
  1. Start FrontPage 2003, and then open the Web page.
  2. In Folder List, expand My_Connection_interface, where My_Connection is the name that you specified in the Database Interface Wizard.
  3. Expand Results, expand editor, double-click update.asp, and then click Code at the bottom of the page pane.
  4. Click Edit, and then click Find.
  5. In the Find what box, type <!--webbot bot="DatabaseRegionStart", and then click Find next.
  6. In the line that you find that starts with
    <!--webbot bot="DatabaseRegionStart"
    find the following:
    Timestamp = '::Timestamp::'
  7. Edit the line to add square brackets around Timestamp so that it reads as follows: [Timestamp] = '::Timestamp::' .
  8. Click File, and then click Save.

STATUS

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

MORE INFORMATION

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

289317 Cannot use the FrontPage Database Editor with databases created by FrontPage

Modification Type:MinorLast Reviewed:1/6/2006
Keywords:kbDatabase kberrmsg kbprb KB828898 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.