Database Interface Wizard

K

kyleq

After using the wizard to create a database interface with an already
existing table I get the following error message when trying to use the edit
function. Sometimes it will tell me one or more fields are empty and
sometimes it will not. No fields are empty.
Any ideas?

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.
 
K

Kevin Spencer

In a Database, a column can allow or not allow null (Nothing) values. In the
case of text columns, it doesn't matter, as a form field left blank will
insert or update a blank string. Of course, in Access, you can also disallow
a blank string. But in the case of numerical columns, dates, and one or 2
others, a blank value in a form can only be interpreted as a null value. If
the column does not allow nulls, you must provide a default value for the
column in cases where the form fields are left empty by the user, or use
client-side form validation to ensure that the form is submitted with all
the required data in it.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Chicken Salad Alchemist

What You Seek Is What You Get.
 
K

kyleq

Thank you Kevin.
The database fields are all text except for the date entered which is the
system default date. I have made sure to put data in every field and the
error still pops up when saved. Any ideas?
Kyleq
 
T

Thomas A. Rowe

Make sure the date field is not named date

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DBI update failure 8
DRW Error 7
Dabase Results Page 14
Database Update 16
Database Interface Wizard 6
Error help 3
DIW - Cant Update records 2
Edit User Information in Database Error Message 9

Top