The system is out of resources or memory (1 Viewer)

[Sokkheng]

In my database ms access when i click preview report it show the message my database was unable to create windows. "The system is out of resource or memory."
I use Microsoft access 2016 MSO (16.0.12527.20260) 64-bit
Please let me know what problems with my database (ms access problem; my report problem; or Window problem? and how to fix it?).
Thanks for any help.
Sokkheng

 

[jdraw]

See the Similar Threads at the bottom of the screen for ideas.

 

[The_Doc_Man]

It is unfortunate but true that neither Access nor Windows will identify which specific kind of resources got depleted. Here are a couple of threads. You can find links to other articles in these threads. One of them is the link mentioned by jdraw. The other is an older thread on a related subject.

Solved - Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

I have a front end database that I've used since about 2002 (in .adp format back in those days) We recently migrated it from 2010 to Office 365 so of course that meant migrating from .ADP to an .ACCDB via Linked tables so we migrated to ODBC linked tables. The SQL backend was 2008 at the time...

www.access-programmers.co.uk

System Resource Exceeded

Bit of a strange one... I've been building a few databases this week, none of which are overly complex. They all happily run on my i5 8GB laptop, but having moved them to run on an i7 16GB, I now get a 'System Resource Exceeded' message each time they run.

www.access-programmers.co.uk

 

[Mike Krailo]

Well that was an interesting read through. Didn't know about the Affinity settings and the table corruption case was very unusual. Will be interesting to see what the solution is for Sokkheng's case.

 

[isladogs]

Microsoft recently made some changes that make this type of error less likely. See my article

Now you CAN open more tables and databases

This short article outlines two recent improvements made to the Access architecture behind the scenes. Taken together, these should significantly reduce the number of 'cannot open any more tables/databases' messages and make it far less likely that Access applications will crash

www.isladogs.co.uk

Not sure which version number of A2016 you have so its unclear whether those changes apply to you.