Out of resources

[sharonc]

Using Windows 2000/MS Access 2000 with Service Pack 2 loaded.

I have a query that is doing a lot of calculations and I'm receiving the error message 'out of resources' or 'system resources exceeded' Does anyone know how I can fix this problem?

 

[link9]

A lack of RAM is the most common cause of that problem.

Solution:
Add more RAM

;-)
Paul Prewett

 

[Guest_imported]

Hello. I am experiencing the same "System resource exceeded" error and I was wondering what ended up being your solution. I am running Windows 2000/IIS 5.0/Access 2000. I get the message after the server has been running for a week or so. It occurs on a recordset.open call. Once it happens, my only current solution is to reboot the system. Then, its ok for another week or so until it happens again. Any help is greatly appreciated. Thanks.

D-J Harrison