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: Newest
Most helpful Newest Oldest
  1. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-12-21T18:03:15+00:00

    Preliminary test using the SQL Server driver showed the same performance for me. I.e. I see little to no increase in Memory Usage in Task Manager and return a cartesian query recordset of over 9.6 million records from a remotely hosted SQL Server with what I consider to be a typical time lapse for a recordset that large.

    I still need to test inserts and updates as well as straight selects, but there's still no confirmation of a reason some people experience this.

    Maybe we should be looking at SQL Server versions as well? The one I'm using is SS 2019.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-12-21T11:01:08+00:00

    Hi,

    On Premises. Here is a connection string example.

    ODBC;DRIVER=SQL Server;SERVER=sqlpc2\sql2019;DATABASE=PT;UID=PTUser;PWD=abc;

    Have you already tried if the problem goes away with a different ODBC driver?

    I ask mainly because in November it was reported that Microsoft screwed up the old SQL driver coming with Windows. I haven't read any reports yet that Access users couldn't connect, but maybe there's a relation here.

    Servus

    Karl

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-12-19T19:24:18+00:00

    Hi Tom, yes we use redemption for emailing. It is very much active a really a great product. I'll be sure to take a spin around the FMS product to see if there are advantages to it.

    Thanks

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-12-17T17:10:42+00:00

    Correct me if I’m wrong, but isn’t “redemption” the older product “Outlook Redemptiin”? I’ve never used it, but I think it assists with automatically dealing with the various security prompts that Outlook pops up when using automation from other VBA-enabled applications such as Access and Excel.

    Is the product still being actively maintained (I honestly don’t know)?

    Have you considered switching to a method that uses an independent SMTP engine, so that when the Outlook team makes changes to the security model, it does not possibly break your application? One possibility, which I have used with good success is FMS’s Total Access Emailer software. You can purchase a developer license that covers any number of Access projects for multiple customers. Something to consider…

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-12-17T16:59:43+00:00

    You’ve taken the prudent action by changing to the semi-annual update option, in my opinion. No point suffering continual “paper cuts” if there isn’t a need to be on the bleeding edge!

    Was this answer helpful?

    0 comments