My SQL Date field interpretation in Access

[John Hickey]

I have a date field in my MySQL table that I am trying to edit in Access, but it is not letting me do it from the Access interface. I can CHANGE the date, but what I am really trying to do is DELETE the date, if one is entered.

In Access when I enter the date field and delete it (space bar it off, etc) and then try to move to the next record I get: "You tried to assign the null value to a variable that is not a variant data type."

In MySQL, it says the field is set up as such: 'date1` datetime NOT NULL default '0000-00-00 00:00:00'

When I try to enter 0000-00-00 00:00:00 on the Access side, (to overwrite a date I am trying to get rid of..) I receive "The value you entered isn't valid for this field." and again I can't save the change.

I need to be able to make the edits from the Access interface, what can I enter in the field that would be accepted?

Thanks!