Forum Discussion
system resources exceeded error
I'll bring this problem to the attention of the MS Access team to see if they are aware of it and if there is a potential fix to address it.
This is a known problem but up until recently, it's been unresolved. However, "... there is a fix for this in version 2010, which is currently available for Office Insders, and will be in Current Channel at the end of this month.
So if you know of instances where this is happening, please try version 2010 if you can to see if it resolves the issue."
George
George_Hepworth Do you have a source link for the known issue status and upcoming Current Channel fix? We have had some success changing processor affinity in the past, but are now seeing these system resources exceeded errors frequently regardless of our affinity settings. (A365, version 2008) I don't see this issue mentioned in the beta or current (preview) channel https://docs.microsoft.com/en-us/officeupdates/update-history-beta-channel.
Thanks!
George_Hepworth , Thanks George, I am re-assured that there might be a solution to this but do I need access to the office insiders channel to fix this?
George_Hepworth hello, George.
Is this matter being looked into at MS to your knowledge?
First time user, and I don’t know the procedure.This is an obvious problem but I don’t know if this forum is just a discussion that is trying to find work arounds rather than the supplier dealing with the problem.
If it is just a forum for solutions, do you know how one would tell MS about this?My contacts with MS online chat and by phone have been to their staff who in essence told me they don’t know the answer as Access is a specialist product, and I have to pay MS a fee to have it investigated. Unsatisfactory.
Today, after splitting my archive table and successfully using the smaller table of more current data, today I turned to access the larger second table in a query, and it failed due to system resources exceeded. MS Access is not functional any longer. To anyone who reads this post, this is not a trivial complaint, but it goes to the core failure of MS to be able to handle data in its application that it has always been able to over the last 20 years.
Even though this a MS forum, does any reader know of a similar application to Access that I can buy as Access is now not usable.
thanks
Neville
This is just a discussion forum where people try and help one another with their Access database related problems.
There are different variation of this issue and I know MS is working on it, but no clue as to how long it will take it if they will fix this specific version of the issue.
With every new version of Access, this problem has been getting worse and worse. This is why sticking with an older version is actually beneficial as you are less likely to see this issue.
Use access.uservoice.com and the feedback command within Access itself to express yourself to Microsoft. Everyone needs to do so if ever things are going to change.
As for alternatives there are tons such as Alpha 5, FileMaker, Zoho, PowerApps, ... But truthfully I would not invest in another proprietary application and would instead turn to PHP/MySQL as it opens so many more doors and there is tons of information, forums, easy to find developers, ...
Thanks.
First, in your first reply, you said version 2010. Do you mean I should install Access 2010? I am using Access 2016.
Second reply, in Run command, I entered
Start.exe /affinity 1 C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE d:\Documents\Racing
Is says Cannot find Start.exe
(I am not a programmer. )
The more I try work arounds in my DB, the worse it appears to be.
The table where the system resources exceeded error appeared had 400,000 records.
I managed to move out 300,000 of these records into another archive file.
Yesterday, my DB was mostly working with the cut down 100,000 record size table. Occasionally, system resources when using it in form queries, but I closed that form and didn't bother proceeding with that one.
TodayI am trying to devise other work arounds that will allow me to continue to add more records to this table, by Copying the 100,000 file to a temp file, clean out original, do my updating to original which has 0 records, then return the temp records.
But now, Access won't even let me do the Copy of the original table, reporting system resources exceeded.
This issue only arose after a W10 update, and then MS updated my Office programs on Thursday.
The MS help people are no use, claiming no knowledge.
Thank you so much for your assistance.
Neville Aganoff
