467,877 Members | 1,278 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Share your developer knowledge by writing an article on Bytes.

Use large address awareness to fix out of memory issues in 32-bit Access

isladogs
Expert 128KB
Some members may have seen that MS plans to introduce large address awareness (LAA) in 32-bit Access. See Microsoft 365 Roadmap | Microsoft 365. Originally slated for Nov 2020, its now been put back to July 2021

I am therefore very grateful to Phillip Stiefel for both explaining what this means and for providing code that will allow you to implement LAA in Access now. See Phillip's article The /LARGEADDRESSAWARE (LAA) flag demystified

I won't attempt to summarise LAA here as Phillip's article explains this in detail. However, the result is that enabling LAA should significantly reduce or eliminate out of memory errors and you may also find that certain processes run faster.

I tested loading several large JSON files into my JSON Analyse & Transform for Access (JATFA) app and noticed some very definite improvements. See Word doc attached for test results

As a result, I have now made both A2010 & A365 LAA enabled. It only takes a few seconds to do

IMPORTANT:
1. You CANNOT run Phillip's code from the same application that you want to make LAA enabled. To make 32-bit Access LAA enabled, you must run the supplied code using a different Office app such as Excel using the Run As Administrator option

2. Any Microsoft 365 updates that update Access will (for now), disable LAA again. You will need to run the code again to re-enable LAA. However, as mentioned, it only takes a few seconds

I hope this information is useful to other forum members
Attached Files
File Type: docx JATFA Tests with LAA.docx (17.6 KB, 17 views)
Jan 22 '21 #1
  • viewed: 1622
Share:

Sign in to post your reply or Sign up for a free account.

Similar topics

16 posts views Thread by Justin Lazanowski | last post: by
3 posts views Thread by tom | last post: by
17 posts views Thread by Frank Rizzo | last post: by
reply views Thread by jack112 | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.