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