ODBC - Call failed error message (1 Viewer)

[aman]

Hi Guys,

I am using Access frontend and sql server backend . There is a select query built on the frontend which is giving me "ODBC - call failed The text, ntext, and image data > types cannot be compared or sorted, except when using IS NULL or LIKE > operator" error message . Below is my query . Don't know what's going wrong Please see the attachment as well

SELECT tbl_FormsCat_FileCheck_Ref_QuestionMatrix.QuestionMatrixID, tbl_FormsCat_FileCheck_Ref_QuestionBank.AreaRef, tbl_FormsCat_FileCheck_Ref_QuestionMatrix.RoleRef, tbl_FormsCat_FileCheck_lkup_Area.Area
FROM (tbl_FormsCat_FileCheck_Ref_QuestionMatrix INNER JOIN tbl_FormsCat_FileCheck_Ref_QuestionBank ON tbl_FormsCat_FileCheck_Ref_QuestionMatrix.QuestionBankRef = tbl_FormsCat_FileCheck_Ref_QuestionBank.QuestionBankID) INNER JOIN tbl_FormsCat_FileCheck_lkup_Area ON tbl_FormsCat_FileCheck_Ref_QuestionBank.AreaRef = tbl_FormsCat_FileCheck_lkup_Area.AreaID
GROUP BY tbl_FormsCat_FileCheck_Ref_QuestionMatrix.QuestionMatrixID, tbl_FormsCat_FileCheck_Ref_QuestionBank.AreaRef, tbl_FormsCat_FileCheck_Ref_QuestionMatrix.RoleRef, tbl_FormsCat_FileCheck_lkup_Area.Area;

 

[Minty]

It's telling you can't compare those fields data types which translates I suspect, in your case, to you can't group on them.

text and ntext data types are deprecated since SQL 2005, so this is really legacy data types. Can you update them to varchar or similar?