ASP to Access DB using "Like" problem

[ChainsawJoe]

this is doing my head in. whenever I do a query in access2k using something similar to;
select * from user where firstname like "Bob*"
everything is fine and peachy. but run this thru ASP using adodb recordset etc, I get;
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

I just can't understand it. It's not the connection to the db, sine if I change the sql to "select * from user" it works fine.

Please people - HEELPP!! )

Muchos gracias.

 

[mage]

HI,

Try using

Select * From user Where username like '%Bob%'
OR
Select * From user Where username like 'Bob'

 

[ChainsawJoe]

no, I think % is for SQL Server Like, not A2K Like. I've tried all possible combinations of these anyway, but to no avail!