English Access 2000 Cannot Display Chinese

[sharlet]

I created a database file with one table in Chinese Access
2000 on Chinese Windows 2000. There is only one record in
the table and the record contains Chinese characters in
some of the fields. It is working fine in Chinese Windows
2000.

Then I try to open the file in English Access 2000 on
Windows 2000 but I only see "squares" instead of the
Chinese characters. I have already got the Chinese
language enabled under "Microsoft Office Language
Settings" and I do not have problem inputting or reading
Chinese characters in Word or Excel on English Windows
2000.

I tried to copy the Chinese Access 2000 sample
database "Northwind" with Chinese characters in it and
open it with English Access 2000 on English Windows 2000.
The Chinese table names can be displayed properly but the
data in the records are still showing "squares".

Could anyone please let me know whether there is any
solution to this problem? As I need to store data with
Chinese characters in an Access .mdb file and put it up on
a web site. If it is not possible then I will have to
look at other alternatives.

Any input would be very much appreciated. Thanks!

 

[ChinaTeacherJohn]

Chinese Charactes MS Access2000 and Windows 2000

I solved this problem a long time ago and just now ran into the problem again. I realize Sharelt has probably long since solved the problem but for those of us still wrestling with this

, there are at least two solutions:

1) The simplest solution is to open your database and then go to the Tools->Options... menu item. On the options dialog go to the "View" tab. There should be an option that says "Dual font support" Click the box that says "Use substitution font:" and then pick a Chinese font. I selected the font: SimSun

2) The more robust solution, in my opinion, especially for a multi-user, multiple computer scenario is to explicitly specify a Chinese font on the forms that display the Chinese characters. That seems to work regardless of the previous setting.

We have a bilingual environment and a bilingual application. The Chinese fonts don't always look good with English text so we have different fonts for different fields. You could even test if there is Chinese in a given field and then change the font as appropriate. (For example, sometimes a parent name or address field is in Chinese and sometimes it is in English.)

I hope this helps someone else or at least me the next time I forget this solution.