ASP ADO Problem

I have an ASP page which makes an ADO connection to an Access database. I then try to create a recordset from a constructed SQL statement but always obtain zero hits. I can run the SQL statement on the database and it works.
I have checked the IUSRpermissions and the odbc setup which looks fine. The code has been checked against samples from books and technet and looks fine.
Any ideas?