LIKE operator

Hai...

I'm facing a problem with LIKE operator of MS-ACCESS using ASP recordset object. I tried to get some recordset using some SQL statement. In that I included the LIKE operator to search for pattern. But, that recordset is returning o rows. But, if I execute same SQL statement in ACCESS Query form, its giving required results. Here, I'm including code and the database also. Can U please tell me the reason...?

Remeber MS SQL and Access differs.

In MS SQL use can use "Select * from tbl where id like %ABC%"

But in Access use must use "Select * from tbl where id like *abc*"

Access queries doesn't always work in MS SQL 7 etc