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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2022-12-15T13:27:47+00:00

    Hi Tom, we are in the process of adding 64bit functionality but have to deall with several external utilities (ex: pdf viewers, redemption, etc) so it's a big job to have our programs work with both 32 and 64. Hoping to have that done in the next month or two.

    We have started adjusting users to semi-annual to get around it also. Better practice to be set to that but my concern is that the issue isn't addressed and it eventually hits all of my customers.

    Thanks

    Was this answer helpful?

    0 comments
  2. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-12-15T13:58:51+00:00

    Further testing on my part (limited time so far, so not thorough) indicates this problem does seem to appear with a remotely hosted SQL Server, but not a local installation on the same computer.

    Please let us know SQL Server Driver versions in use, and also are your users linking to a remotely hosted SQL Server or an on-premises SQL Server.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-12-15T14:15:42+00:00

    Correct the Sql Server is on a server that we connect to via odbc.

    Having the issue with both SQL Server 2017 and 2019 at my office.

    Was this answer helpful?

    0 comments
  4. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-12-15T14:58:48+00:00

    Remotely hosted or on-premises?

    The SQL Server Driver is in the connection string.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-12-15T15:07:23+00:00

    On Premises. Here is a connection string example.

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

    Was this answer helpful?

    0 comments