Hi all, first time posting to any forum, anywhere, ever. Apologies in advance if any mis-steps.
I'm using this code to search a MS-Access database:
Rs.Open "SELECT * FROM products WHERE ACTIVE = TRUE AND TITLE LIKE '%" & Request.Form("KEYWORDSEARCH") & "%' ORDER BY VENDORPN ASC", OBJdbConnection
If I search for something numberic, like 325, works great. If I search for something purely text, like hat, it seems to run for a long time and then I get an error, I think some sort of buffer overflow. If anyone can help I'd be indebted.