This error generally occurs when attempting to use the "Insert Record" or the "Update Record" server behavior to set the value of a column in Microsoft Access to an empty string ("").
This error most often occurs when using Microsoft Access. Access is characterized by strong data typing; it imposes a rigorous set of rules on given column values. The empty string value in the command text (SQL) cannot be stored in MS Access data fields that do not allow zero-length strings.
Check the column names in your database against your query string to make sure that the spelling is correct. In other words, ensure that all of the field names in your SQL statement are spelled correctly.