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?