Type mismatch error on some machines

[tazforcenz]

I have written a program in C++ Builder which connects to an Access 2000 database through ODBC and uses the SQL statement below. I get an error "General SQL error. [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression" when this statement is run on the client's Windows 95/98 machine. This error doesn't appear and the query works fine on a Windows ME/2000/XP machine. Is this an ODBC driver issue or something else? All machines have Access 2000 installed.

SELECT ParameterName, SUM([a03/01/2002]), SUM([a04/01/2002])
FROM TempTable
WHERE DivisionID = 7
AND MachineGroupID IN (SELECT GroupID FROM Groups WHERE DivisionID = 7 AND GroupName = "flexo&quot
AND Show = true GROUP BY ParameterName

Need some advice. Thanks.

 

[Guest_imported]

I have a similar problem not solved jet. But maybe you should use single quotes (') in the where criteria instead of double quotes (&quot

 

[Guest_imported]

Try removing quotations(single or double, doesn't matter). I removed quotations, it worked. Somehow Access doesn't like quotations in the SQL strings