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.