How do I resolve a collation conflict in Access

Within Access I am trying to query a remote server using an ODBC connection and join on a reference table on our local server but I get the following message.

  Cannot resolve collation conflict for equal to operation.

I know that if this was SQL, I could just add "COLLATE SQL_Latin1_General_CP1_CI_AS" to the JOIN and things would work.  I have tried that in Access but it doesnt like it.  So how do I get this working in Access?
WedmoreAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
GRayLConnect With a Mentor Commented:
In Access Help type - Create an SQL-specific query (MDB) - click on the phrase - then click -  Create a pass-through query that sends commands to an SQL database.  You should now be able to add the "COLLATE clause to the query.
0
 
GRayLCommented:
Thanks, glad to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.