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
Printable View
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
First check that zero length strings a/o Nulls are allowed in the field in Access.
allow zero length is not available for a datetime field in mdb.
can i get a null value or zerolength string from the field?
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.