Microsoft Access Memory Issue after December 6 2022 Build15831 Office Update

Anonymous
2022-12-13T20:25:43+00:00

I've found that Access programs are running out of memory or getting system resources exceeded errors after the recent office update. If I open task manager and watch the memory resources the continue to go up and are never released like they normally do. This was not an issue until the update last week. Working in O365 32 bit access.

Anyone else experiencing this?

Microsoft 365 and Office | Access | For business | Other

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

69 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-12-22T14:49:39+00:00

    It also finally just dawned on me to ask the various OP's if the less- and non-performant queries are aggregates (i.e. have group by clauses in them).

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-12-22T14:42:03+00:00

    Hi George,

    The question was more directed to the people affected by the problem like SKIRK_70. It seems that in addition to the M365 version there is sth involved that we didn't detect so far.

    If the affected people would like to see more exactly when (and thus by what) their virtual memory is eaten up they could either use the external tool VMMap from Microsoft or some lines of VBA code using the GlobalMemoryStatusEx API.

    I showed both methods in the video already mentioned in this thread and all the material incl. the tool and sample code is still available in my downloads at AUGET. Maybe this helps to detect what's involved.

    Servus

    Karl

    Was this answer helpful?

    0 comments
  3. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-12-22T13:19:57+00:00

    Pure queries generated for testing. I ran one Update query, which didn't perform any different from the select queries.

    I will try the suggestion of incorporating some queries into a form today.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-12-22T10:18:02+00:00

    Hi,

    Too bad it's not the driver ;-) We know so far O365 32 bit version 2011 different builds have it, with version 2010 it goes away. Different versions of Windows and different ODBC drivers are affected.

    What else could make the difference that it doesn't happen for all?

    @SKIRK_70 Are these really "pure" (select?) queries that you execute, or are they queries that are behind Access objects, i.e. forms or reports?

    If the latter, that might be worth another test, George, because the classical problems with virtual memory happen most often with forms.

    Servus

    Karl

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-12-21T20:01:43+00:00

    Good point on this update being the tipping point. I believe I covered closing and setting recordsets to nothing but will take another pass through to make sure nothing was missed. Based on the feedback I'm not real optimistic they will release a fix anytime soon so I need to find a work around.

    Thanks for the feedback!

    Was this answer helpful?

    0 comments