Description
There were reports that Office update 2405 was causing slowness loading forms in Access. Some users were reporting that eventually Access was then crashing. Microsoft confirmed an increase in crash reports for this update version which appears to affect builds starting with 2405 17628.20110 released to Current Channel starting on May 30, 2024.
According to several reports, the problem has been occurring again in version 2407 since August 1.
There are detailed bug reports in these forums for Version 2405:
For Version 2407:
In the comments attached to this article
Cause
Unknown.
Status
The bugfix from Microsoft had originally fixed the problem for the Current Channel with Version 2406, Build 17726.20126 and for Current Channel (Preview) with Version 2406, Build 17726.20118.
The bugfix is for the version 2407 issue is now available for Current Channel with Version 2409, Build 18025.20096 and Current Channel (Preview) with Version 2409, Build 18025.20090.
There is a probably less "popular" variant of the problem where things slow down when the "Properties" property is used many times in code. This is currently being investigated by Microsoft. When we get an update on that we will let you know!
Workaround 1
Try not to install version 2407 or roll back to an older build if you have already done so.
Agreed about version 2408. We have a form in our application that relinks a lot of SQL tables, views and stored procedures. The actual time taken to relink these SQL objects also increases with each load of the form. So, the process is load form, press to relink, start timer, finish relink, stop timer, close form. The first relink takes 26 secs and gradually gets worse, so in this example it went 26, 32, 34, 35, 37, 36, 38.
I then closed access and began again, this time it went 26, 33, 36
Problem is still present in Access version 2408 ( Build 17928.20114 ) unfortunately.
It looks like the problem is back. Starting at Access version 2407 ( Build 17830.20138 ). It was fixed in 2406, but we see the exact same problem. Opening forms is getting gradually slower with every form we open.
We have just received reports from a customer facing this exact problem with the current release of Office LTSC 2021, Volume License version (16.0.14332.20721, v2108, Perpetual Enterprise Channel).
Is it possible that this bug slipped into 2021 LTSC VL with the June 2024 update?
Thank you.