Hi, I'm working a database that uses a lot of queries. I need to calculate different interest rates each month and different transactions. Everything is working for the first 4 months fine, but when I go to get a total for May, I get a error that "System Resources Exceeded". The database is only 3 mb in size but I do use about 13 queries per month to do all the calculations. Is there a limit to the number of queries you can run?
Microsoft Access database query specifications Attribute -------------------------------- Maximum
Number of enforced relationships ---- 32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships
Number of tables in a query ----------- 32
Number of fields in a recordset ----- 255
Recordset size ------------------------------- 1 gigabyte
Sort limit ------------------------------------ 255 characters in one or more fields
Number of levels of nested queries - 50
Number of characters in a cell in the query design grid -------- 1,024
Number of characters for a parameter in a parameter query ---- 255
Number of ANDs in a WHERE or HAVING clause ------------------- 40
Number of characters in an SQL statement approximately - 64,000
Hope this helps.