|
Home > Archive > MS Access Multiuser > December 2005 > Convert from English to French on the fly.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Convert from English to French on the fly.
|
|
| Bernard Piette 2005-12-13, 3:24 am |
| HI,
I've designed a very complex database (60 tables x 550 fields x about 150
relationships) and have come up against a huge obstacle. The database is
curently designed completely in English but my customer is in Quebec and so
it needs to be bilingual. How in the world can I convert everything structure
and data to be in both languages. Super Simple Examples is in English we say
Mr. or Mrs. and in French we say M. or Mme. for men and women.
This is essential to follow Quebec language laws and something tells me this
will be a gargantuan task :-\
Any help or pointers to scripts or anything will be much apreciated.
ps: I posted here and table design was not certain the more apropriate group.
--
Bernard Piette
| |
| Alex Dybenko 2005-12-13, 7:24 am |
| Hi,
Just an idea - for tables you can try to use application.saveastext to
"export" tables to text, and then translate and load back.
Actually i have a solution to make application multilingual, but this is for
user interface, not for tables. you can look at it here:
http://www.pointltd.com/Products/Details.asp?dlID=33
--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
"Bernard Piette" <the1@community.nospam> wrote in message
news:E847E246-CC07-4584-BF39- 92487B1B71E0@microso
ft.com...
> HI,
>
> I've designed a very complex database (60 tables x 550 fields x about 150
> relationships) and have come up against a huge obstacle. The database is
> curently designed completely in English but my customer is in Quebec and
> so
> it needs to be bilingual. How in the world can I convert everything
> structure
> and data to be in both languages. Super Simple Examples is in English we
> say
> Mr. or Mrs. and in French we say M. or Mme. for men and women.
> This is essential to follow Quebec language laws and something tells me
> this
> will be a gargantuan task :-\
>
> Any help or pointers to scripts or anything will be much apreciated.
>
> ps: I posted here and table design was not certain the more apropriate
> group.
> --
> Bernard Piette
| |
| Bernard Piette 2005-12-13, 8:26 pm |
| Alex, Thanks for the heads up,
I'm sending my programmer to analyse the links you pointed out.
again Thanks
--
"Alex Dybenko" wrote:
> Hi,
>
> Just an idea - for tables you can try to use application.saveastext to
> "export" tables to text, and then translate and load back.
>
> Actually i have a solution to make application multilingual, but this is for
> user interface, not for tables. you can look at it here:
> http://www.pointltd.com/Products/Details.asp?dlID=33
>
> --
> Alex Dybenko (MVP)
> http://alexdyb.blogspot.com
> http://www.PointLtd.com
>
>
> "Bernard Piette" <the1@community.nospam> wrote in message
> news:E847E246-CC07-4584-BF39- 92487B1B71E0@microso
ft.com...
>
>
|
|
|
|
|