Access 2016 Out of Memory

slogwood
slogwood used Ask the Experts™
on
I had this question after viewing Out of Memory Error when trying to compile MS Access 2013.

I have workstations running windows 10 x64 office 2016 x32. most of my workstations have 32gb of ram installed on them. i have a front end db which is at 100mb and a backed db at 600mb. i get an out of memory error periodically when trying to import forms in the the front end and then run a compiler on the db to resolve bugs and issues. i have tried doing a decompile, compact and repair, then recompile and get the out of memory error. what steps can i make to resolve this issue?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Seth SimmonsSr. Systems Administrator

Commented:
I have workstations running windows 10 x64 office 2016 x32.

even though most users would only need the 32bit version, some would need the 64bit version especially dealing with larger data sets.
uninstall office and install the 64bit version and it should work better

32bit applications can't address more than 4gb so having 32gb won't get you far (though the OS supports it) without using a 64bit application that can address larger memory spaces
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
I would strongly recommend against 64bit office as there are very few ActiveX controls that will work in that enviroment, and most people do not need more than 4 GB for a normal Access application.

I would start out by building a new front-end from a blank database and importing all of the current FE objects into that new file.  Then compile everything and compact and repair.  This error message is common when you have a corrupt project file or even just a single corrupt object in the FE.

Dale
Sam Simon NasserIT Support Professional

Commented:
I'm with the option of removing the 32 and install the 64 bit (whole office or just access).

can you try this scenario: since most of your computers are 32g, did you tried to open the same file on other computers? does the same error on other machines? or they work fine? maybe there is other software on your computer that is consuming memory or making conflict with access.
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

Most Valuable Expert 2012
Top Expert 2014

Commented:
I would agree with Dale - don't install Office 64 bit. Larger datasets are relevant to Excel, but not Access. An Access database can be up to 2 GB regardless of the "bitness" of the Office install.

If you're having troubles importing objects into a database try to perform maintenance on the database first, as Dale suggests. Also be sure to perform these operations on local copies of those databases. Don't use networked copies for things like this.
slogwoodIT Manager

Author

Commented:
Yes I agree that 64bit installation of office is not a solution due to the extensive programming my applications have with ActiveX controls. I have already rebuilt the front end several times and done decompile, compact & repair db, compile approach. This has fixed issues in the past. Doing this on a local copy of the db front end does not resolve the issue as well. The issue seems to be when creating new forms and adding additional control objects. It seems that access is acting like it has reached some type of capacity limit somewhere, but there is no notification of what or where the error is occurring.
Most Valuable Expert 2012
Top Expert 2014

Commented:
Have you done as Dale suggests and create a new, blank database and import everything into it? Sometimes the container gets corrupt, and the only fix for that is to create a new one.

Access has limits on the number of objects it can contain, and those are "lifetime" limits. If you're in the habit of creating and deleting Forms, for example, it's possible that you have reached one of those limits. However, you generally don't get out of memory errors when that occurs, you will instead receive an error message stating you've reached those limits - something like "Access can't add any more Forms".

If you have already rebuilt, then the only other thing I could suggest would be to repair or reinstall Access, and make sure that you're fully up to date on all your Office and Windows updates.
slogwoodIT Manager

Author

Commented:
Yes I have rebuilt the database several times. The out of memory error occurs randomly. I don't think the issue is related to the copy of access installed considering I have a team of developers who get the same issues periodically on different workstations.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial