How do I make wildcards work in sql thru ado?

[Herbatic]

I've got a tricky problem, I can't fix it in msdn, so what to do? time to come to you gurus here at vbforums

The situation is I'm accessing an access 2000 (jet) database from vb6 using ADO. when i try and open a recordset based on this string:

SELECT Files.[FileID], Files.[File Name], CDs.[CDID], CDs.[CD Name] FROM CDs INNER JOIN Files ON CDs.CDID = Files.CDID WHERE ((Files.[File Name]) Like 'gladiato*');

it returns 0 records. If I run the same string directly in an Access query it works fine and i get 1 record 'gladiator'. also if i change the 'gladiato*' to 'gladiator' then it works thru vb.

It seems to me that i can't use wildcards in the sql string from vb. does anyone know if this is correct, and if it is, does anyone know a way around it? my program sort of revolves around this working, it's a searching program