Hi,

I've been googling for the better part of a day now and have yet to come up with a proper solution for this issue.

1) We have an existing access accdb that ties in with SQL 2k5 via the microsoft SQL server odbc driver.
2) Linked tables are used within the system.
3) We were originally storing just english characters in a column of the SQL DB which is of nvarchar type.
4) Storage of russian and english characters works without issue. Access see's the characters correctly and allows anything to be put in via forms. That is, browsing and updating records via access forms is not an issue.

The issue:


When we try to query using russian characters, or use the DLookup function - the correct result is never returned. Presumably this is because SQL is converting the text to a non unicode string before trying to perform the query.

I've tried many possible variations of trying to query integrating the N prefix that you use with SQL queries, without ever being able to get access to return the correct result. E.g.

The following query works fine when executed on the SQL server:
Select Name From People WHERE Name Like N'%unicodeCharactersHere%'

The equivalent in access does not work:
Select Name From People Where Name Like N'*unicodeCharactersHere*'

Is there some other way to do this, really at the end of the road in terms of ideas. Any ideas would be massively appreciated.

Thanks for any suggestions