Hi - I'm getting the dreaded "system resources exceeded". Sometimes happens randomly, but mostly I notice it when looping through a recordset (and not a very large one at that). I've tried to make sure I don't keep objects alive, and my global arrays are not very large. It seems to be mostly a Windows 7 issue from my googling (?) Using Access 2013. Microsoft seems to offer a fix but I've not read a consistent success story.
P.S. Looping through a small rset can trigger it for me, but when I then close and restart Access, I can loop through a much larger rset using the same module, and it works fine. Feels like a memory leak or something in Access.
Thanks.
P.S. Looping through a small rset can trigger it for me, but when I then close and restart Access, I can loop through a much larger rset using the same module, and it works fine. Feels like a memory leak or something in Access.
Thanks.
