Ron Grabowski wrote:
I'm using the OleDb libraries to connect to an Access database.
I recieve the following error:
[OleDbException (0x80040e07): Data type mismatch in criteria expression.]
The exception occurs when EndDate exists in the Hashtable:
map["EndDate"] = DateTime.Now;
I once had very similar problem when updating Date/Time field in Access database. If I remember right, my exception occured when I tried to update DateTime object with time part containing other than 00:00:00 into Access Date/Time field with "Short Date" format setting.
Try altering Access field's format to "General Date" or using DateTime.Today instead of DateTime.Now as value to be updated.
I hope this tip helps.
Cheers
Jarmo Ollikainen
