I get sometimes the error "MyField cannot accept null values" if I INSERT INTO and do not specify all field names in a table. The not specified field names should be blank and not null, and I could not find out what setting causes this to happen.

Any ideas?