I have a VB6 app using DAO to connect with Access database. The last two days users have been getting Error Code 3035 System Resource Exceeded when doing a simple query. Example: "SELECT * FROM APHF01 WHERE (APHFCheckNo = '999999');" The table APHF01 has around 200,000 records. It is also occurring when executing on a different table with around 30,000 records. The tables have a small number of columns ~20. Any ideas on why this would come up and what can I do about it?

Thanks.