Query - System Resource Exceeded ERROR

[DH]

When trying to open a form in Access 2000 I am getting a "System Resource Exceeded" error. I also get the same error when trying to open the query that the form is tied to so obviously the error is in response to the query trying to run. This error seems to have started to occur when I upgraded/converted from Access 97 to 2000.

Any suggestions on how to corrected the error to get the query and form to open correctly without the error?

THANKS!

 

[Hulkman]

Make sure you have the latest service pack for Access 2000. Access has a habit of eating up all the system resources no matter how much ram you have. The latest service pack should have the fix.