Forum Discussion
system resources exceeded error
gnarlesvI'm on a SQL server 2014 back end with ODBC connections to an Office 365 front end. My application is always up to date. This error occurs when you have too many connections open to the data source at one time. It usually happens to me when I have multiple datasets open either on forms on in tables and I leave the database open overnight.
A big culprit of this error are having too many open recordsets. One thing to check if you're coding in VBA is to make sure that you're closing out your recordsets by setting them to nothing. Another thing to check is the number of DLookups you're using. DLookups leave an open connection and can seriously tie up resources.
I've used a DLookup substitute called Elookup by Allen Browne for years. It really helps with this issue. Here's the link: http://allenbrowne.com/ser-42.html
HTH,
Patrick
ppaton open record sets may be the explanation. My code is lengthy mostly sql but it does have record set in it.
Even now as I have worked around the problem of resources exceeded by creating smaller temporary tables to work with, I do get code stopping occassionallly at an open record set command. It goes into debug mode, and I just hit F5 a couple of times to continue and let it finish without problems.
I must not have a record set close command.
I’ll take a look.
Thanks
