Saving data in ms access database from software on 32-bit platform runs perfectly well..But when I try to save data using same software on 64-bit application throws below error:
**System.Runtime.InteropServices.ComException. Datatype mismatch in criteria expresssion. **
I have declared some variables as SHORT in my application and in database those fields are defined as Long Integer or Integer..
Eg. WardNo variable in software is defined as SHORT and in ms Access database,WardNo is stored As Integer..
On 32-bit,it doesnt show any error,but on 64-bit machine,error occurs..Please help me to solve this...