I'm having a serious problem here. I'm trying to update a table, but it keeps giving me an error: "data type mismatch in criteria expression".
I saw that there were allready lots of problems on here, but none was able to help me.
I'll give some more details.
The above is my update query.
I can tell you the teh GeneralID is a text.
and the checkDate makes the input as a string in "yyyy-mm-dd"- version.
The genValue is a String.
This GeneralID is also the Primary Key in my table.
A weird thing is that if I update the table with the field OrderID, it works.
So, I have really no idea anymore what it is.
I hope it is something stupid that I looked over.
But I hope someone can help me...
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!