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. Anonymous
    2022-12-17T16:31:11+00:00

    Hi,

    ...The Access program reports "out of memory" but there seems to be plenty of memory available. Windows reports 5% memory use - this is a machine with tons of memory. Access.mdb is linking via ODBC to both local and remote SQL Server instances. Popup message reports "Out of Memory"...

    The 5% Windows reports are about RAM. That's a different movie.

    This kind of memory error message refers to the so called Virtual Memory. That's the abstracted memory an OS provides to processes/applications. If you use a 32 bit version of Access then Windows limits the virtual memory to 2 GB by default. I've once explained this in more detail (what, how to measure, workarounds etc.) in a presentation for AUG ET

    . Others like Phil and Mike have then also written about it.

    It doesn't matter how many RAM or whatever physical memory a system has. The virtual memory for the application stays at 2 GB if you don't set the LAA switch described in all 3 above mentioned sources.

    We have documented the problem discussed in this thread in our new Access blog and will keep that article up-to-date. What we would still need for a really good bug report to Microsoft is a reliable reproduction scenario.

    Servus

    Karl

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Tom van Stiphout 40,216 Reputation points MVP Volunteer Moderator
    2022-12-14T13:39:50+00:00

    It appears you are speaking of the Current Channel, which gets updates early. I find it too aggressive for Production systems. I would recommend backing off to a slower channel. Search online for "change office update channel" and you will find there are several ways depending on finer points.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-12-14T12:37:57+00:00

    Thanks for the confirmation. We've notified the Access team and called their attention to this thread. Keep a watch on it for any further developments.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2022-12-13T23:24:56+00:00

    These are on premises sql servers all at different locations.

    Thanks

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-12-13T22:45:54+00:00

    Thanks, "... 10 customers with the issue and each just received the office update." is a pattern.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments