Date/Time - Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[theflyingminst]

Hi I am getting this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

This is my SQL statement (goDate is in 2/15/2009 format. I'm thinking that might be my problem?.. It IS a date/time field in Access).

SQL = "insert into calendar (event, cal_date, username) values " & _
"('" & new_event & "','" & goDate & "','" & my_usernm & "');"


Thank you

[chazzy]

it is. you have to use something to convert the string (since SQL is a string when you build this variable it becomes a string) to a date. Try using CDate.

[Charles]

Give #2/15/2009# a try.

[theflyingminst]

Hi, #2/15/2009# worked. Thank you!

[vinothvijay]

it may be difference in the date option, for Eg: You have created a database in UK server and if you copy the database in you local and try to update this thing it wont work because UK/US date format is totally different when compared to Indian date format
For India 25/12/2011
For UK it 12/25/2011
so when you are updating in the database it wont accept you have change the format.