Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Posts
    13

    Unanswered: System Resources Exceeded Error

    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.


    Sincerely,
    Gregorio E. Gonzalez
    Gregorio E. Gonzalez

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Check free space on your local hard drive.

    Igor

  3. #3
    Join Date
    Jul 2002
    Posts
    13
    Free Space is 7 GB Annnnnddd... I have tried it on another system, I have rebooted the system, Both of these comptuers are running 2k, Annnnddd... I'm pulling hair out of my head...

    This should work, I have no idea why it's not... Is it another one of Accesses restrictions that I have become soooo accustomed to??

    Greg
    Gregorio E. Gonzalez

  4. #4
    Join Date
    Nov 2001
    Posts
    336
    MDB size can't exceed 2GB. Check the size after 16th query.

    Just my 2 cents.

    Igor

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •