Forum Discussion
Office update 2405 17628.20110 causes slowness in loading forms in MS Access
Dear Karl_Donaubauer thanks for providing the bugreport to microsoft.
We have now also identified the issue with the Monthly Enterprise Channel 2407 version. HeinziAT fyi.
The issue in the 2407 version is also in the current channel 2408.
The issue is with reading properties of an object. Below is a sample helper function that reads the value of a property on a form.
I have made a test database, see attached. In this test database is a FormSpeedtest with 1 control. And in the Form_Load we do 100 times a 2000 readproperty call. What we see is that this gives stable timing for 2406, but in 2407 (monthly) and 2408 (current) timings increase significantly. See attached Excel file with the timings.
The code in the attachment reads the property with the function call. But even if you read the property directly in the form_load with me.Tekst0.Properties("text").value (in stead of the readproperty call). The issue appears.
The decrease in performance of the application is permanently, untill you close and re-open the application.
Can you share this also with Microsoft?
Thanks,
Ron
Thanks for the detailed analysis, that was very helpful. I can confirm your results regarding the Current Channel issue: If we remove all radio button groups from our test form (plus one text box, more on that below), the problem disappears.
There seems to be an additional issue, though. Remember the text box I mentioned earlier? It's control source is an expression referencing another control, e.g. something like `=Iif([someStatusCheckBox]=True,"Done","")`. We also needed to remove that text box (after removing all the radio button groups) to make the "performance leak" disappear.
Creating a minimal example for that issue is harder than usual, since the removal of other, non-related controls from the form also makes the problem disappear, so I'll only that do if someone requests it.
Best regards
Heinzi