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)
Any idea? Why would it generate above error?
I would greatly appreciate your quick response.