Make 32-bit Access large address aware (LAA)
Now that the 32-bit version of Outlook 2016 becomes large address aware (see https://support.office.com/en-us/article/Large-Address-Aware-in-Outlook-2016-ea0913e4-2917-4456-b0ea-935dbd57ef02), it would be great to get that for MS Access as well.
(We hit the 2GB barrier every now and then when batch-exporting MS Access reports as PDF. Having 4GB support would be great. Upgrading to Office 64-bit is usually not an option in corporate environments depending on third-party add-ins.)
Philipp Stiefel commented
Access Applications that show multiple forms, each containing several subforms, side by side run into out-of-memory-errors very quickly. This is a completely reproducible issue. Currently the only mitigation is to limit the number of open forms. To reliably prevent the issue a max limit of no more than 5(!) forms may be required.
Klaus Oberdalhoff commented
Excellent idea, that would minimze my crashes because out of memory ... mfg Klaus Oberdalhoff
Stephan Kraft commented
Some complex MS Access Applications don´t run with Access 2019, because there is not enough free virtual memory.
The only way is to transform the 32 bit version into 64 bit.
A lot of work for nothing.
B. Clothier commented
When you consider that there are Access applications that has worked in previous versions, and the only difference is that they upgraded to a new version of Access, it becomes a HUGE disincentive for them to consider upgrading the application, which is also bad in terms of supporting because that broadens the scope of support. If you want them to upgrade, you need to be able to provide same experience they had with the previous versions -- not running out of memory just because they only have 20 forms open. Access has long ago published a specification of hard limits and that has not been changed since. Enabling the LAA would be a simple way to enable those complex application continue to run well on newer versions of Access.
Karl Donaubauer commented
I've often read it as a problem in forums and e-mails I get from desperate Access users and developers. Access and its objects (especially forms) need more virtual memory with almost every version. A lot of existing, working applications with complex forms etc. break because of this increase when people try to use them in newer versions. So far there's no real solution for the problem. This could do the trick for many people.
Juan Soto commented
I endorse this idea whole heartedly! Excel has joined Outlook as mentioned here: https://support.microsoft.com/en-us/help/3160741/large-address-aware-capability-change-for-excel
My clients are constantly getting error messages with complex Access applications that require code to minimize the memory footprint. If you agree, please vote for this improvement AND LEAVE a comment for the Access team explaining WHY this is needed.