Right. I'm sure the wildcard character used within Access is "*", whereas when using SQL through ADO it is "%"
Also using the LIKE operator makes the comapre ignore the case.