I currently have a database doing 16 make table queries which use functions that I have created. When I attempt to run the 17th query, I get the "System Resources Exceded" error. The actual database is quite small (8 MB) and this query is NOT based on anything but 2 tables and a simple query.
I have attempted breaking up the query, manually and automatically and I still get the same error. I have also compacted the database and compiled all of my functions.
Please Assist... I don't know what to do, and I'm running out of time.