Problems with index on fields using accents

[Guest]

Hi,

I have a problem with accented characters in indexed fields in Access.

The Database:
I created a small database using French Access XP on French Windows XP SP2.
It has one table called Test and one field called Field_Text. There are two
pieces of data in the table:
Geo
Géo
and an index is built on this field.

The Code:
I wrote a small VB program that uses ADO to attempt the following query:
SELECT * FROM Test
WHERE Field_Text LIKE 'Gé%'
and the query returns no results.

This same query finds 'Géo' if the index is built on an english machine, if
there is no index built or the index is removed.

I have a workaround: WHERE Field_Text LIKE 'G[é]%' but this is a little
clumsy.

Is this a known limitation with French Access XP or am I experiencing a bug?

Thanks in advance,
RobL
i2 Ltd.

 

[Sophie Guo [MSFT]]

Hello,

These newsgroups are geared to answer on the English version of the
product. For support for localized versions please use the support
resources appropriate to that language.

Thanks for cooperation.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.