Access Linked to SQL Server - Using Not Equals

[Chad Access]

I have the following:





I want to make notes <> "Some Expression"

However, writing the traditional way, the ODBC connection fails. If I run it the way it is in the picture, it runs just fine.

Any ideas for me?

[pbaldy]

What is the exact criteria and error you got? I just tested against a linked SQL Server table and it worked as expected.

[pbaldy]

Is Notes a memo field in Access? I rarely use, and wonder if that causes a problem. I'll try to find one and test it.

[Chad Access]

Yes, it is a memo field.

[pbaldy]

Also worked as expected against a memo field.

[Chad Access]

"The data types ntext and varchar are incompatible in the equal to operator". The field is ntext in the sql table. Then I am just comparing it to a text string by saying <> "Text String"


UPDATE: I changed the field on the SQL Server side to varchar(max) and it works properly now. Hooray!

[pbaldy]

Haven't run into this one, but I don't use ntext. Some thoughts from a quick search:

https://blog.sqlauthority.com/2012/1...l-to-operator/