Help and Support

"Database Results Error" error message when you update a database record in FrontPage

View products that this article applies to.
Article ID:256136
Last Review:January 27, 2007
Revision:3.2
This article was previously published under Q256136

SYMPTOMS

After you use the Database Interface Wizard to create a Database Editor Web page, you may receive an error message similar to the following:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
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.
-or-
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Field 'Table Name. Field Name' cannot be a zero-length string.
Number: -2147467259 (0x80004005)
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.
where Table Name is the table in the database, and Field Name is the field in the database.

Back to the top

CAUSE

This problem can occur if you attempt to update a database record that has an empty field. The setting for the database column does not allow zero-length entries.

Back to the top

RESOLUTION

To resolve this issue, make sure that all data fields that do not allow zero-length entries are populated before you submit the form.

Back to the top

WORKAROUND

To work around this issue, start Microsoft Access and then open the database table in Design view. Set the Allow Zero Length attribute to Yes for each field that you want to allow blank entries.

Back to the top

MORE INFORMATION

For additional information about this error message, click the following article number to view the article in the Microsoft Knowledge Base:
287147 (http://support.microsoft.com/kb/287147/) FP: Error Message: "Database Results Error" When You Update a Database Record

Back to the top

REFERENCES

For additional information about reserved words in SQL queries, click the article numbers below to view the articles in the Microsoft Knowledge Base:
209187 (http://support.microsoft.com/kb/209187/EN-US/) ACC2000: Reserved Words in Microsoft Access
286335 (http://support.microsoft.com/kb/286335/EN-US/) ACC2002: Reserved Words in Microsoft Access

Back to the top

APPLIES TO
•Microsoft FrontPage 2000 Standard Edition
•Microsoft FrontPage 2002 Standard Edition

Back to the top

Keywords: 
kbconfig kbwizard kberrmsg kbprb KB256136

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.