NULL to Datetime in MSAccess

[sanjays]

hi,
how doi insert a null value to a datetime field in MS Access table? an empty string and NULL are not accepted.
how do i update the already set date value of a datetime filed to null ?
pls let me know soon ,
Regards
sanjays

[salvelinus]

First check that zero length strings a/o Nulls are allowed in the field in Access.

[sanjays]

allow zero length is not available for a datetime field in mdb.
can i get a null value or zerolength string from the field?

[Qualm]

Access datetime fields must allow nulls. You can test for IsNull and you can SET field = NULL.

One problem you can potentially have is that the OLE DB driver might treat "empty" date fields differently - for example the Visual Foxpro OLE DB driver passes "empty" date fields to vb.net as "12/31/1899". Boy did that one cause a headache.