Forum Discussion
Access VBA performance dramatically slowed since June Update
We are running an access based application with a large vba project.
One customer with four different instances of this project experience extreme slow down in performance on all instances during the last week. We made no changes. The Microsoft Office Update was applied automatically. We believe the problem happened then. We have tried reverting to several different previous versions of Office but symptoms still remain.
7 Replies
I have a software product with lots of customers. I am getting a lot of calls about the VBA performance problem. As mentioned here, this was introduced in version 2606 somewhere around Build 20131.20024 and was fixed in Build 20131.20050 (I believe). Current channel preview updates seem to get you up to 20068 and so the problem is fixed. HOWEVER, current channel users are getting version 2606 build 20131.20044 which still has the problem. I have a lot of people have called me in the last several days that have that version and when you try to get updates, it says you are up to date. Microsoft needs to push out the fix for this to the people that they sent version 2606 that are on current channel. Now they will say that people on the current channel should not have version 2606 build 20131.20044 but a lot do. Please fix this!
Hi,
We recently learned from Microsoft, that even the default Current Channel is "subject to experimentation", which means that a part of the systems in this channel get builds which are listed to be in the Preview Channel.
This explains why some people got the buggy build and can't update, as in their channel there's no newer build available. They can a) switch to a different channel or b) wait for a fixed build or better actively choose File - Account - Update Options - Update Now as often as possible, to get a fixed build as soon as Microsoft has released it.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEKYou can also explicitly download a newer build if it is not getting downloaded through the update now button. Just open a command prompt as administrator and use the following example:
"C:\Program Files\Common Files\microsoft shared\ClickToRun\OfficeC2RClient.exe" /update user updatetoversion=16.0.20131.20090
Hi,
A heads up for people who are on Current Channel Preview and have this problem:
You should now be able to use File - Account - Update Options - Update Now to pull Current Channel Preview version 2606 build 16.0.20131.20052 that contains a fix for this bug.
When you do that, please let us know, if the problem is solved for you.
The problem also exists in the Beta Channel, where the fix should arrive with the next upcoming build.
Servus
KarlHi,
Unfortunately, you do not mention in which update channel, versions and build numbers you see this problem.
In case this happens in the Current Channel Preview version 2606, then it could be a known problem that Microsoft is currently fixing (see also the immediately preceding thread in this forum).
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK
