Acces 2007 Dlookup function and accentuted characters

[Janeks]

Hi!


I recently run into problems when found that Dlookup does not work corectly with strings that contain accentuated non latin characters. I.e. Dlookup returns Null when there was accentuated characters in criteria expression even if in table was corresponding record.

It worked in Access 2003 on another PC. The database format is Access 2003. But when I converted it to 2007 the problem was the same.

Does anybody faced with the same problem?
Are there any solutions?

brgds & thanks in advance,
Janeks

[Janeks]

The problem was in Regional and Language Options under Advanced tab, where Language for non-Unicode programs was set to Russian.

I unset it back to Latvian and now it works as expected.


But any way it seems for me strange.


So the next question could be how can i detect this setting from Access VBA, so I can at least warn a user.