quote by techgnome:
Actually it's an Access/SQL issue, not an ado one... Access uses '*' as it's wildcard, while SQL uses '%'....
It's also an ado issue, oledb provider dependent (jet4.0 vs odbc driver)
http://support.microsoft.com/default...NoWebContent=1
http://support.microsoft.com/default...NoWebContent=1