Access 97 to Access 2003 DataBase conversion

[Jacques Trépanier]

Hi,

We work in a mostly french environment. We have a standard image using MUI
Microsoft products (XP and Office 2003 are MUI) Since the convertion of an
ACCESS 97 BD into Access 2003, we experience a sort sequence problem when
using:

DoCmd.Openform or DoCmd.ApplyFilter

A selection on a name like "Coté" will return no record. Asking for "Cote"
will return all records including "Coté".

I suspect a problem with MUI (multi-user interface) but I did not find any
recommandation at Microsoft.

Thanks.

 

[Tony Toews [MVP]]

We work in a mostly french environment.

If you don't get a useful answer here I'd suggest asking in the French
Access newsgroup. I suspect many of us unilingua Anglophones,
including me, don't have a clue about multi lingual issues.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Jacques Trépanier]

Tony,

I have tried in France before coming here. NewsGroup are great to get
yourself on track to troubleshoot issues.

Regards,

 

[Tony Toews [MVP]]

I have tried in France before coming here. NewsGroup are great to get
yourself on track to troubleshoot issues.

Darn. I've asked my fellow MVPs, some of whom are definitely not
Anglophones to review your posting.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

What database sort order are you using? Sometimes when
a database is upgraded from 97 the settings are not right.

MichKa (Michael Kaplan) is the man to ask :~) He was an
Access MVP, and is a MS internationalization guru, although
he probably won't thank us for being mentioned here...

http://blogs.msdn.com/michkap/


BTW: I HATE GOOGLE GROUPS.

Search for
guid kill group:*access*

Do you get ANY access groups at all? Can you find this classic
MichKa posting:
http://groups.google.com.au/group/microsoft.public.access.modulesdaovba/msg/fe9290a80eb2ef4c
by searching for key phrases? Has the Ministry of Truth taken over?

I would recommend that you search for what MichKa had to say
about sort order and upgrading from 97 to 2000, but I can't
recommend a search engine that would let you find it.

 

[Alex Dybenko]

Hi,
Access is still not 100% Unicode (VBA first of all), perhaps control panel's
regional settings-advanced-language for non-Unicode programs setting could
help here, try to set French there

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Tony Toews [MVP]]

BTW: I HATE GOOGLE GROUPS.

Search for
guid kill group:*access*

It looks like Google groups no longer supports a * in the front of the
group keyword only after. So microsoft.public.access.* does work.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Jacques Trepanier]

Hi,

I was away and just came back.

We use to have French Windows 2000 computers. So I re-image an old computer
with a French Windows 2000 O/S and the same problem happens.

I will try what you have suggested.

Regards,