check your date for blank and if it is so insert null into the date field.
so your update statement could be like this..
"UPDATE tablename "+_
"SET date_field =" & iif(trim(ldDateField)="","null","#" & ldDateField & "#") & ",.." etc.
Best Luck..
Nilesh