Error Messages

Give this a shot and lets see if it will help.

sounds like a memory leak to me.

Did you run down the troubleshooter?

Daniel Pieault replied to a similar question on some Microsoft Community Forum. The person that started the post had the issue had 64 GB of Ram and a 1 TB drive and don't recall the video card.  Here is what Daniel posted:

First it is important to understand that Access does not access all of a computer's RAM, so having 16, 32, 64 GB RAM changes nothing.  Access has access to a limited amount of RAM which depends on the bitness of Access.  64-bit version can access more RAM, so this can be one solution, switching from 32-bit installations to 64-bit, but that can also make for work depending on the complexity of the database (ActiveX, APIs, ...).

Also, with each new version of Access, the core program itself consumes more and more of the memory leaving less and less for the database itself to use to perform operations.  This is why databases that previously ran fine suddenly start generating this error on more recent versions of Access or after some new update from Microsoft.

How big is you file?  It may also be the case that queries are using temporary storage and causing the database to grow beyond the 2gb file size limit.   Have you compacted your database recently?

Some people have reported that changing their CPU affinity to 1 in the task manager for the Access app solved this issue.  May be worth a try.

Some have had success by breaking complexe queries into simpler operations and chaining them together.

There is a little bit more but it ends with going back to an earlier build of Access that doesn't have the same memory limitations.

All good advice