Multi-lingual Access application

[thehill]

I am developing an application in Access that will be deployed to numerous
sites around the world.
All of the user interface needs to display in the language of the PC that it
is running on.
I do not want to have to have different versions of the .mdb file, and i
dont really want to have forms for every language either as this will make
updates a nightmare. This leads me to think each piece of text needs to be
tagged and then lookup the correct text based on the regional settings.

Does anyone have any better way of doing this, i have searched high and low
but cannot seem to find any good resources on this.

 

[Tony Toews]

I am developing an application in Access that will be deployed to numerous
sites around the world.
All of the user interface needs to display in the language of the PC that it
is running on.
I do not want to have to have different versions of the .mdb file, and i
dont really want to have forms for every language either as this will make
updates a nightmare. This leads me to think each piece of text needs to be
tagged and then lookup the correct text based on the regional settings.

Correct but there was a posting indicating that, if you roll your own
solution, the most important performance hit was to read the tables
containing the translated text and update the captions from there.
Don't try to read each caption and then lookup the corresponding value
in a table as that will be many reads for a busy form and performance
will be terrible.

Microsoft Access Multilingual/Localization Solutions
http://www.granite.ab.ca/access/multilingual.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[thehill]

thanks for the links. has given me a few things to think about, need to go
and double-check the customer's requirements and then go from there.
thanks again for your help