e = E = É = è = é

T

Toxalot

If I search for e in MySQL it will return e, E, É, è, and é etc. If I
search for e in an Access, it will return e or E.

I've tried using an Access query and I've tried through VBA/ADO.

Is there something I can do in Access so that it will see all accented
letters and non-accented as the same?

Jennifer
 
W

Wayne-I-M

You can change the regional settings of the keyboard

Go to Control Panel
Go to Regional and Languages
Select Options
Select Languages

Or use the character map (but this will not see e and ë as the same)

Start
Go to All Programs
Go to Accessories
Go to System Tools
Select any (or all) characters
Save and close
 
Top