I recently migrated my backend from access to SQL 2000. And I am using ODBC DSN to link SQL backend tables to ACCESS frontend. It seems to be working fine except few queries which are all update query (with one to many relationship).
Those query generates a weird error :
ODBC - Call failed . [Microsoft] [ODBC manager] Invalid argument value (#0)
I am being able to exucute update queries on Numeric fields but it's not working on textual field. Is that a data conversion issue???
Any idea? Why would it generate above error?
I would greatly appreciate your quick response.