Share via

"System Resources Exceeded" and Affinity (Access 2016)

Anonymous
2020-01-07T20:26:44+00:00

When trying to open a table (MS Access 2016, fully patched), I get a message "system resources exceeded".   

I can eliminate this error if I set the task affinity to use only one CPU.   

Powerful PC - 8 core Intel i7.  16 Gb memory.

Is there a patch for this issue that prevents us from using multiple CPUs at a time?   

(Research indicates that this defect has been an issue for years now, going back to Access 2010)

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-01-14T20:47:30+00:00

    Pretty sad - I've done some searching, and I found posts from 10 years ago complaining about this.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2020-01-14T20:45:42+00:00

    Running Microsoft Office 365 ProPlus.

    I get the error when I run queries that include "Group By" clauses.    Everything works after I go to Task Manager and set the affinity to use only one CPU (My PC has 8 CPUs).

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2020-01-11T08:53:57+00:00

    Hi Danh4_PA, 

    Did you check all the replies above? If there are any updates, please post back here at your convenience.

    Best regards,

    Dihao

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-01-08T05:06:56+00:00

    Hi Danh4_PA,

    From your description, when you open an Access file with Access application, you will receive a “System Resources Exceeded” message. First of all, I

    would like to confirm with you which Office version you are using either you are using Office 2016 suit or Office 365 ProPlus. You can go to File>

    Account > Under Product information page to find it. If it is convenient, you can share a screenshot of the problem information page with us here.

    As Daniel mentioned, you can also share more detail information about what are the processes you did before you received this message. Does this message only happen in certain Access file or all your Access files?

    In addition, I also did some researches based on the message. I found a similar thread about Ms access 2016 System resource exceeded. You can refer to rodrinn’s post to set affinity in Task manager. You can have a look at your convenience.

    Best regards,

    Dihao

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-01-07T20:32:35+00:00

    As you stated, this issue has long existed and no, I'm not aware of any official fix for this. What you are doing is the only thing I am aware of.

    Was this answer helpful?

    0 comments