And, in case you find yourself using ADO, here is how you can test to see if a column supports nulls:

#DEFINE ADFLDISNULLABLE 32
nAttributes = oRecordset.Fields("myfield").Attributes
If Bittest(nAttributes,5)
*/ Field supports nulls
Else
*/ Field does not support nulls
Endif