Dave,
I had similar problems with FoxPro and I'm not sure there's just one answer. If you have existing data with date fields, you should make sure that all empty dates are set to .null. Also, make sure that any fields that can be empty are flagged as nullable. With one table, I ended up having to create a custom data access object.
Linda
Linda Harmes
HiBit Technologies, Inc.