Article ID: 256136
Article Last Modified on 1/27/2007
APPLIES TO
- Microsoft FrontPage 2000 Standard Edition
- Microsoft FrontPage 2002 Standard Edition
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:
-or-
where Table Name is the table in the database, and Field Name is the field in the database.
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.
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.
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.
MORE INFORMATION
For additional information about this error message, click the following article number to view the article in the Microsoft Knowledge Base:
287147 FP: Error Message: "Database Results Error" When You Update a Database Record
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 ACC2000: Reserved Words in Microsoft Access
286335 ACC2002: Reserved Words in Microsoft Access
Additional query words: front page update sql dbase
Keywords: kbconfig kbwizard kberrmsg kbprb KB256136
