Forum Discussion
system resources exceeded error
i have been using access for many, many years and am using a current office 365 version (2009) with windows fully up to date on an lenovo thinkpad with 32gb ram etc. while i had sporadically gotten t...
I haven't experience specifically this issue; however, I received many error messages related to custom VBA functions created in Access 2002/2003/2007/2010. All error were gone after changing the MS Access 2016/2019 installation from 64 Bit to 32Bit, which its backward compatibility support of MS Access works much better with these custom VBA functions.
Note: I Know the main reason and the 'PtrSafe' fix for those errors caused by older VBA functions, we choose to remove them as well. I did not have option to fix these 'PtrSafe' errors, and continue, may be the next error could be the "... system resources exceed error" .
If you have subscription with these two versions, the default installation is 64 bit. You might want to try installing 32bit of Office instead. Aside from that, if your database have linked tables to some external sources such as QuickBooks and Sage 300, you have to have the 32 bit anyway. I have to say that both QuickBooks and Sage 300 support 32 bit of Office 365 (2016) and Microsoft 365 (2019) while your Windows 10 is 64bit, they do not support 64 bit of Office.
Following steps might not exact, but very close for installing 32 bit of 365;
- Check your installation in Add/ Remove Programs
- Continue if its 64 bit, or stop if its already 32 bit.
- Login to your Microsoft Account,
- Select Office Product, Office Products page opens,
- Open down arrow near Install button, select 32 Bit,
- Download - the default download folder is your C:\yourprofile\Downloads,
- Uninstall 64 bit of office,
- Install 32 bit using the file you downloaded
Note: I Know the main reason and the 'PtrSafe' fix for those errors caused by older VBA functions, we choose to remove them as well. I did not have option to fix these 'PtrSafe' errors, and continue, may be the next error could be the "... system resources exceed error" .
If you have subscription with these two versions, the default installation is 64 bit. You might want to try installing 32bit of Office instead. Aside from that, if your database have linked tables to some external sources such as QuickBooks and Sage 300, you have to have the 32 bit anyway. I have to say that both QuickBooks and Sage 300 support 32 bit of Office 365 (2016) and Microsoft 365 (2019) while your Windows 10 is 64bit, they do not support 64 bit of Office.
Following steps might not exact, but very close for installing 32 bit of 365;
- Check your installation in Add/ Remove Programs
- Continue if its 64 bit, or stop if its already 32 bit.
- Login to your Microsoft Account,
- Select Office Product, Office Products page opens,
- Open down arrow near Install button, select 32 Bit,
- Download - the default download folder is your C:\yourprofile\Downloads,
- Uninstall 64 bit of office,
- Install 32 bit using the file you downloaded