How to do a MS Access accent insensitive Query?

How to do a MS Access accent insensitive Query?

That's the question... ;-)

I need to provide english user the ability to find name containing accents without entering them.

Thanks
Yann de ChamplainAssociateAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kellysgreenCommented:
case insensitive and differing character sets are two different issues altogether.

So you are looking to be able to have a search for "yelle"  return "yellé" ??  I'm not sure you can do that -- the ASCII values of  an e and an é are pretty dissimilar.
kellysgreenCommented:
Oh, and this might be better answered in http://www.experts-exchange.com/Databases/MS_Access/
Yann de ChamplainAssociateAuthor Commented:
Yes I amlooking to be able to have a search for "yelle"  return "yellé".

It is possible in MS SQL Server, Oracle....
But I nee to do it in Access.
 I do not want to migrate the bd becasue this app will be rewrited to access from Active Directory.
kellysgreenCommented:
Hmm... a little digging and I found the SOUNDEX function.  It's not perfect, but seems to be the best method... It appears you can use the DIFFERENCE function w/ a threshold level to determine sameness between two values...

Resources:
http://www.dhs.cahwnet.gov/aids/HIVReporting/SOUNDEX/SOUNDEX.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_3o6w.asp

http://databases.about.com/library/weekly/aa042901a.htm



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Yann de ChamplainAssociateAuthor Commented:
Thanks for the effort.

I cose the subject.  After I've seen your documentation, I see that I should wait to be able to migrate to AD.
I give you the points anyway.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Languages and Standards

From novice to tech pro — start learning today.