Hi All
I have asked this too often in too many places and im starting to get depressed.
If you are in a table you can select FORMAT|FONT... and in Access 97 you have an option to select SCRIPT.
In this option you can choose Western, Greek, hebrew, Central European etc.
In 97 i can link to a table that contains greek data. This produces garbled data. By simply changing the script (FROM Western TO Greek) my problem is solved.
But in Access 2000 this option does not exist - but I still get the garbled data. This confuses me and is driving me mad.
This is what I understand:
Access 97 is an ANSI - based application, and the data in the database file is not stored in Unicode. Hence the result of the interpretation of characters is based on the current codepage. A complex script is necessary.
Access 2000, on the other hand, stores data in Unicode. Hence it does not need to enable manual script selection for the fonts, as the script needed is defined by the data itself.
My question is, if I have the right regional settings - why should a linked (DBase) table show garbled data in Access 2000? Hasn't unicode solved everything? Can anyone point out the big hole in my logic?
Thanks to anyone with any idea.
Stew