| Provider error '80020005' Type mismatch
Unable to find solution |
Staffa
msg:4101744 | 2:07 am on Mar 21, 2010 (gmt 0) |
I've been hitting a brick wall for the last 14 hrs or so.
Writing a small script in classic ASP to update 3 numbers in a table in MS Access, something I have done umpteen times, however this time I'm stumped.
Updating 3 number fields in a 4 field record, 2 fields would update as expected if it wasn't for the third field throwing an error : Provider error '80020005' Type mismatch.
When I take the third field out of the update the other two update the numbers perfectly.
I have been looking all over the web and while I found questions about this error they only had some roundabout answers but no definite solution.
If anyone here knows, please share, many thanks in advance.
|
bmcgee
msg:4101771 | 4:46 am on Mar 21, 2010 (gmt 0) |
Your SQL string is probably using a wrong type. For instance if you are updating a string field, you need to wrap the value in ticks. And dates need formatting.
|
dstiles
msg:4102012 | 9:16 pm on Mar 21, 2010 (gmt 0) |
Another fault I've come across is the field name being a reserved word - eg Type.
|
Staffa
msg:4102014 | 9:18 pm on Mar 21, 2010 (gmt 0) |
Thank you bmcgee, your suggestion would work fine for a VBscript runtime error but this is a different kind of error.
One way or the other I will crack this problem. :)
|
Staffa
msg:4102208 | 9:21 am on Mar 22, 2010 (gmt 0) |
Thank you dstiles, that was one of the first things I checked.
In the meantime I've solved it, so it's OK now.
Thanks again.
|
|
|
