Date/Time - Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
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 & "');"
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.
“The power of the Web is in its universality. Access by everyone regardless of disability is an essential aspect.”
—Tim Berners-Lee, W3C Director and inventor of the World Wide Web
Hi, #2/15/2009# worked. Thank you!
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)