>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?

Check SET NULL command in Help. This question was recently discussed and I think your best bet would be to list all fields in your INSERT command.