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.)
Anonymous
shared this idea
Thank you for your feedback. This work is in scope to be completed within the next few months. The Access team appreciates your patience in advance.
33 comments
-
Stephan Kraft
commented
I generally deliver the tool for activating the LAA function to customers with every installation of our software. The tool is also available for download.
http://www.dokuwork.com/DokuWork-Download/large%20adress%20aware.exe
The only problem is that with newer MS Access versions, the setting is reset with every Office update. Fortunately, with the 2010 this no longer happens (support has expired).
For German-speaking users there is an explanation here. http://www.dokuwork.com/dokumente/large%20adresse%20aware.pdf
-
Philipp Stiefel
commented
As Microsoft takes it's time to implement this feature, it might be helpful to read my text on how to hack the LAA flag right now.
https://codekabinett.com/rdumps.php?Lang=2&targetDoc=largeaddressaware-msaccess-exe -
Stephan Kraft
commented
In the meantime I think that it is fake news if the MS team has been talking about providing the LAA functionality for MS Access in "the next few months" for over a year. I think it is a corporate policy decision by Microsoft not to support LAA for Access. Despite all contradicting assurances. The pressure with Excel and Outlook was probably too great, but actually one wants to let the 32 bit Office version die (double support effort).
In my Access customer applications, I have therefore been using LAA with third-party software for several years without any problems.
Fortunately, the MS Access Runtime 2010 has dropped out of Microsoft support and is therefore no longer updated. Set msaccess.exe once for LAA = unlimited use. Newer Access versions do not bring more than the 2010. Some even less so.
If at some point in the next decade LAA is supported in the then current MS Access version, I will be happy to use the newer Access version. Alternatively, I use the 2010 Access version until Saint Never's Day.
-
Killer
commented
You indicated in May 2020 that this would be done 'in the next few months". It has now been eight months since then, and this is still in "planned" status. When will this be fixed?
-
Hansruedi
commented
+1 thank you
-
Anonymous
commented
Yes Please add it.
-
Anonymous
commented
Yes, please add it ASAP to Access.
-
Admin, 3D-plastic
commented
Just patch Access with /LARGEADDRESSAWARE...
(see https://www.insidesql.org/blogs/2019/12/20/minimize-access-32-bit-memory-problems-on-64) -
Klaus Neidl
commented
Do it ASAP!
-
Andreas Heiderstaedt
commented
Yes Please add it.
-
Dieter Staudenmaier
commented
I agree to the other posts - please change the barrier
-
Anonymous
commented
I agree with Stephan, he wrote:
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.
-
Anonymous
commented
We wait for the LAA
-
Anonymous
commented
Yes, please add it
-
Adrian Bell (MVP)
commented
@Stefan.
Please understand that comments for or against an idea in here are appropriate.
Diluting, or otherwise trying to adjust the original request that people have been voting for and commenting on is not so much. It would make managing of requests impossible.As for making such a change to older versions that you suggest, I believe this is outside of the scope of their management in that changes to older versions are restricted to security changes only.
If you believe, in spite of what I say, that this should be considered then what you must do is to post it as a suggestion in its own right. Adding it in here can only distract.
-
Stefan Wurmb
commented
Please also add this flag to the older 2010/2013 Versions too. They are still being used.
-
Peter Fors
commented
Will this solve the issue "Cannot open more databases"?
-
Josef Schasching
commented
PLEASE change this, I have very often this problem
-
Anonymous
commented
https://accessusergroups.org/et/event/access-et-2-2019-12-20/ (Video by Karl Donaubauer + Files)
https://www.insidesql.org/blogs/2019/12/20/minimize-access-32-bit-memory-problems-on-64 (First half is german, second the english translation) -
Bob Alston
commented
Yes Please add it.