>>>Hi All,
>>>
>>>I am using VB with 'Microsoft.Jet.OLEDB.4.0' to connect to ACCESS 2000.
>>>
>>>My problem is that everytime I use the LIKE Operator in my queries I get no records back.
>>>
>>>Should I avoid LIKE in queries through OLEDB 4 to Access tables?
>>>
>>>(BTW the query works perfectly when run directly from Access.)
>>
>>You need to use the % wildcard instead of the *
>
>Merci.
>
>Is that because of how OLEDB is built?

Yes ADO has changed the wildcard operator.