I used ADO method to load ACCESS2000

=========================================
Directly DEBUG in ACCESS

select count(*) from user where name like '%q%' Cont't query the result£¨But It can before)

select count(*) from user where name like '*q*' Can get the correctly result

select count(*) from user where name like '%%q%%' Cont't query the result£¨But It can before)

==========================================
In my ASP web

select count(*) from user where name like '*q*' memory overflowed

select count(*) from user where name like '%q%' memory overflowed

select count(*) from user where name like '%%q%%' memory overflowed

==========================================
What's wrong with this?