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?

Can you post the exact error message you received from the ASP code?

What are you trying to do ? How big is the database/table you are querying ?