Nov 27, 2007

"Field cannot be a zero-length string" error

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.

Using the table design tool within Access, ensure that the parameter "Allow Zero Length" pertaining to the field you are attempting to modify, is set to "yes".