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

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:

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.

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.

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

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