isladogs
MVP / VIP
- Local time
- Today, 03:04
- Joined
- Jan 14, 2017
- Messages
- 18,563
@Mike Krailo
Please see Philipp Stiefel's article: which was originally linked in post #12 but I've just seen the OP has since edited that section out
The article is at:
Philipp's code MUST be run from another VBA program such as Excel with that run as an administrator as elevated privileges are required.
I just added 3 convenience functions to Philipp's code so I could run it on my dual installation of 32-bit Access 14/16:
Please see Philipp Stiefel's article: which was originally linked in post #12 but I've just seen the OP has since edited that section out
The article is at:
The /LARGEADDRESSAWARE (LAA) flag - Remedy for out-of-memory errors
How to apply the /LARGEADDRESSAWARE (LAA) flag to the MsAccess.exe to get rid of out-of-memory and resources exceeded errors.
codekabinett.com
Philipp's code MUST be run from another VBA program such as Excel with that run as an administrator as elevated privileges are required.
I just added 3 convenience functions to Philipp's code so I could run it on my dual installation of 32-bit Access 14/16:
Code:
Sub SwitchAccessLAAOff()
Debug.Print "---------------------------------"
SetLaaFlag "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE", TurnOffLaa
Debug.Print "---------------------------------"
SetLaaFlag "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE", TurnOffLaa
End Sub
Sub SwitchAccessLAAOn()
Debug.Print "---------------------------------"
SetLaaFlag "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE", TurnOnLaa
Debug.Print "---------------------------------"
SetLaaFlag "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE", TurnOnLaa
End Sub
Sub CheckAccessLAA()
Debug.Print "---------------------------------"
SetLaaFlag "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE", DisplayLaaStatusOnly
Debug.Print "---------------------------------"
SetLaaFlag "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE", DisplayLaaStatusOnly
End Sub