Forum Discussion

rkessels's avatar
rkessels
Brass Contributor
Jun 05, 2024

Office update 2405 17628.20110 causes slowness in loading forms in MS Access

We experience issues with the May 30 release of Office 365, from version 2405 17628.20110

 

We experience issues with Microsoft Access. The issue that we experience is that loading and closing of forms takes longer and longer when you are using the application. Basiccally what we see is that the drawing of the form takes longer each time a form is opened.

 

We have written a recursive function to illustrate this:

 

 

When we execute the function, this are the results:

 

 

…..

 

…..

 

….

 

 

In above overview you can see that when we start the access application the loading of the form takes approx. 0,3s, and the closing of the form takes 0,05s

After 100 opens the timings are 0,5 and 0,3s

After 200 opens the timings are 1,4s and 1s

After almost 300 opens the timings are 2+s and 1,8s

 

When we execute this same recursive function in an older version of Microsoft access the timings are stable.

We have tested this with several forms. And we see this with all forms. The only difference is the loading speed – which depends on the number of objects that are drawn on the form. The more objects the slower and the higher the increase in becoming slower.

 

Anyone knows if this bug is already reported / fixed by Microsoft?

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor

    Yours is the first report of a potential problem I've seen.

     

    If you can provide those stats from tests you ran on the last previous version and on the new version of Access, we can pass them along to Microsoft.

    Upload the stats as text or csv files, please. And if you can provide an accdb which displays this problem for replication, that would be great as well.

  • AndreaR1966's avatar
    AndreaR1966
    Copper Contributor

    I'm experiencing this problem, as well. Did a lot of tests in search of a solution, the only things I could verify is that the slowness occurs even when opening / closing forms in Design mode, and that memory usage slowly increases as forms are opened/closed. After some tens of open/close, closing a complex form (opened in Design mode and NOT changed in any way) can take 6-8 seconds. Only solution is quitting and restarting Access.
    This is exhausting on some PCs, where the workflow involves continuously opening and closing forms for data entry, and where after a few minutes of operation closing a form puts Access in "Not responding" mode for a few seconds...

  • hlau_msd's avatar
    hlau_msd
    Copper Contributor

    We have many of our customers with this issue as well. I was able to replicate the issue in version 2405. And rolling back to version 2404 resolved the issue. Here is a screenshot of the time in seconds to load one of our forms. You can see that as the form is opened and closed, the longer it will take for the form to load in version 2405. While it takes around the same time to load in version 2404.

Resources