Converting Access Application for Japanese use

[kndavies]

Hi,

I have an Access application that I need to convert to work in Japanese and English (ie on start up select your language). Furthermore it needs to run on both Japanese and English spec. computers.

The application contains a large amount of vba, forms/subforms etc as you would expect, and exports and formats reports in Excel.

I can see from other posts that this is not going to the simplest of tasks so if anyone is able to give me a checklist of all the issues I will have to deal with, or point me to any other resources that can help I would be very grateful indeed

Thanks in advance,
Ken

 

[missinglinq]

1) Order in at least a case of rice wine!
2) Take a deep breath, a very deep breath!

The very first thing to understand, I think, is while you may have a single starting point where your user picks English or Japanese, you will actually have to have TWO databases, perhaps with shared tables.

Here are two sites that might help. The first is from MS'Online Office Partners thing:

http://office.microsoft.com/en-us/marketplace/EM011202151033.aspx?CategoryID=CE012295101033

"Point Limited offers MS Access Translator, an add-in for Microsoft Office Access that lets you quickly make applications multilingual. First, Translator collects text information from Access forms, reports, and toolbars, and controls (labels, text boxes, etc.). The developer then translates collected texts to other languages, and finally Translator writes the translated text back to Access controls. Able to work with a variety of character sets, including Western, Japanese, and Cyrillic."

This second site offers some pointers including some advice vis a vis US/Japanese OSs and versions of Access:

http://www.rhialto.easynet.co.uk/jwinfaq/jwinfaq.txt

Good luck, my friend!

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[kndavies]

Hi Missinglinq

Thanks for those tips and pointers, esp. the Rice Wine!

I shall set too - it's not needed 'til 1st November!!

Ken