Saturday, January 17, 2009

Accesss database Error Field 'Database field' cannot be a zero-length string.

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'.

No comments: