This topic is locked

adding allow null to db values posted

6/27/2005 4:09:03 PM
ASPRunnerPro General questions
W
workingfool author

Where and how do I add an allow null function to permit users to leave a blank field without getting this error:
[Microsoft][ODBC Microsoft Access Driver] Field 'data.pre_co' cannot be a zero-length string.
I am using a map path method to an access database.
data_add.asp? and I'm unfamiliar with wrappers, etc...so just not sure where to add and what the syntax is for adding. Thank you.

admin 6/29/2005

You need to open "data" table in MS Access in design mode and check

off "Allow zero length values" for "pre_co" field. This will allow empty

values in "pre_co" field.