I am trying to update MS-Access database where one field is boolean and updating a string. I am getting a error message "Conversion from string "Update Claims set appointed=" to type double is not valid". HOW DO i RESOLVE THIS ERROR
1 Replies - 2001 Views - Last Post: 08 February 2010 - 03:46 PM
Replies To: Conversion from string to type double is not valid
Re: Conversion from string to type double is not valid
Posted 08 February 2010 - 03:46 PM
Please show the complete UPDATE query with the update value/variable reference. And clarify what you want to do, your description is confusing. You want to update a string field with Boolean? Or are you updating Boolean with a string? The error message indicates attempt to update a numeric field failed (is Boolean datatype field treated as double?). Is the update value coming from control on form?
Page 1 of 1