>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 *