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 No comments

69 answers

Sort by: Most helpful
  1. Anonymous
    2022-12-14T13:49:02+00:00

    Hi Tom, unfortunately some of my customers are set this way. We make recommendations but their IT dictate the update policy. I'll have changing to semi-annual in my back pocket as an option as it comes up.

    Thanks

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2022-12-14T08:21:12+00:00

    Hi, we have the same issue at a customer's since build number 15831.20208 (2211). Also running 32 bit office, running an access app with sql backend.

    We noticed this first a couple of days ago from a user that was in the insider channel and was already running 2211. The problem disappeared when rolling back to 2210. Now version 2011 has gone to the current channel since yesterday and all users that have updated notice the same issues with memory usage.

    Also when checking the task manager, it's noticeable that access uses a lot more memory now.

    Was this answer helpful?

    0 comments No comments
  3. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-12-13T22:50:48+00:00

    Is it possibly a problem with the SQL Server database? Are all customers hitting the same SQL Server instance? Hosted instance? On premises instance?

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2022-12-13T22:16:02+00:00

    I have not tested all of my apps but as of now it is one accdb having the issue. It's split with Sql backend. So I've had about 10 customers with the issue and each just received the office update. No updates or changes on my end.

    I edited the 2nd message. I'm seeing growth when running queries but after closing the query it stays at the same memory usage.

    Appreciate it. Let me know if you need any further details.

    Was this answer helpful?

    0 comments No comments
  5. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-12-13T22:06:07+00:00

    It may be a bit early to conclude this is a bug from the update, but I'll pass it along anyway. Also, can you confirm the breadth of the problem? Is it limited to one accdb or to all of them you use? Oh, and other environmental factors as well? Split accdb with FE on users computers and a BE on a network? Same performance problem for all users? And so on. The more details you can provide, the more likely it will be someone can help identify a possible source for the problem.

    Was this answer helpful?

    0 comments No comments