I have a system which Access 97 is front end, and SQL server 2000 is back end. Currently, I am upgrading my Access 97 front end to Access 2000 front end. Some query don't work after the upgrade. There is an example:
Table Name: TestTable (in SQL Server 2000)
Fields: Name (varchar)
ID (bigint)
Query: INSERT INTO TestTabble (Name, ID) Values ('userName', '')
This table is linked to Access, and the type of ID shows Text in both Access 97 and Access 2000. This query works fine in Access 97, but it doesn't work in Access 2000. The error message is "odbc--insert on a linked table failed [microsoft][ODBC SQL Server Driver] Invalid character value for case specification (#0)"
Does anybody have any idea? Thank you a lot in advance!!
--Shamous
Table Name: TestTable (in SQL Server 2000)
Fields: Name (varchar)
ID (bigint)
Query: INSERT INTO TestTabble (Name, ID) Values ('userName', '')
This table is linked to Access, and the type of ID shows Text in both Access 97 and Access 2000. This query works fine in Access 97, but it doesn't work in Access 2000. The error message is "odbc--insert on a linked table failed [microsoft][ODBC SQL Server Driver] Invalid character value for case specification (#0)"
Does anybody have any idea? Thank you a lot in advance!!
--Shamous