Database Error

[Brent Conner]

Hello,

I am try to update database records using Frontpage,
however when I click the "update" button, I receive the
error:

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.

I have looked at the Kb and and have changed all the
fields in the MS Access table to allow Zero Length
entries, but I still receive this error. Can anyone help?

Cheers!
Brent

 

[Dave]

Some things to consider.
1. If you are using Timestamp, look at KB 287147 and 289387.
2. Make sure you are not using any access reserved words for field names.
3. Date fields cause FP to have problems. Consider using text
4. If you don't have an autonumber primary key, consider adding one. This
just resolved a similar problem in the FP2003 beta.

Dave mewhirter