Field cannot be a zero-length string Database error.
Sample Error
Microsoft JET Database Engine error '80040e21' Field 'fieldname' cannot be a zero-length string.
Solution or Workaround
You can receive this error message if you modify the PDshop database column properties incorrectly. Most PDshop database fields (aka columns) should allow a zero-length (NULL) value.
To resolve this error, Using the Microsoft Access program, go into "Design View" for the table mentioned in the error. You would need to change the column properties for the field named in the error. For example, change the "General" setting for the column/field, the setting to change is 'Allow Zero Length', the value should be set to 'Yes'.
To resolve this error, Using the Microsoft Access program, go into "Design View" for the table mentioned in the error. You would need to change the column properties for the field named in the error. For example, change the "General" setting for the column/field, the setting to change is 'Allow Zero Length', the value should be set to 'Yes'.
Related Articles
Related Topics
Search for help...