UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> 2019-08 Windows Updates May Cause Invalid Procedure Call Error In Vba, Any Version    
 
   
PhilS
post Aug 16 2019, 06:03 AM
Post#1



Posts: 614
Joined: 26-May 15
From: The middle of Germany


Hi Everybody!

This is an FYI post. The issue mentioned here cost me a couple of hours yesterday. So, I think it might be worth posting to save you the time diagnosing this issue on your own.

The most recent 2019-08 Windows Updates may cause an "invalid procedure call error" in VBA code. This is not limited to Microsoft Access but affects all VBA-enabled applications.
The problem was acknowledged as a known issue by Microsoft already. Here is a link to one of the KB articles regarding the update. https://support.microsoft.com/en-ph/help/45...pdate-kb4512508

This affects all current versions of Office/VBA on both Windows 10 and Windows 8.1. – I did not investigate if Windows 7 is affected as well.
I just published a more extensive text on the invalid procedure call error after the 2019-08 Windows Updates. That text also includes sample code to reproduce the error in two scenarios.

Best regards,
Philipp

--------------------
Go to the top of the page
 
DanielPineault
post Aug 16 2019, 07:08 AM
Post#2


UtterAccess VIP
Posts: 6,832
Joined: 30-June 11



The impact is quite wide spread from certain reports. Someone just reported it impacted "Access 2003 developer extension". Dismal quality control, nothing new, it is the norm with Microsoft - Release ASAP and update again and again and again... crazy.gif

It's blunder after blunder (Windows, Office, ...). Worse is that they (i) don't immediately stop the rollout of the update when initially reported, (ii) are extremely slow to release fixes (see: https://support.office.com/en-us/article/ac...en-US&ad=US - More than a year waiting!). They don't need competitors, they are their own worse enemy!



If you rollback/revert the update everything works properly again. Until which time Microsoft makes an update for the update to address this latest of bugs.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
GroverParkGeorge
post Aug 16 2019, 07:35 AM
Post#3


UA Admin
Posts: 35,656
Joined: 20-June 02
From: Newcastle, WA


I think we need to put a link to this post on the front page. I'll check with the admin team.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
DanielPineault
post Aug 16 2019, 07:46 AM
Post#4


UtterAccess VIP
Posts: 6,832
Joined: 30-June 11



Since we're at it, here's yet more links on the subject:

According to one person, the issue is due to https://portal.msrc.microsoft.com/en-US/sec...y/CVE-2019-1182 and thus the update/bug would possibly impact Windows 7 through 10 and Server 2008 through 2019.


This is even now hit mainstream media, see:

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
LeeAnn
post Aug 16 2019, 08:01 AM
Post#5



Posts: 1,273
Joined: 2-February 00
From: Mississippi USA Central Time Zone


Thanks for the update. I work for a company that is always on top of getting updates to us as soon as they can. I have not heard of any problems so far but I am going to keep my eyes open.

I want to take a few moments and say I apricate all I have learned from here. I don't post too much here but the ones I have posted I know have been some interesting ones (especially the last one pertaining an issue with jpgs being displayed on Dot Net Nuke, it has been solved but it was a crazy way to do it and I would have not been able to figure out without the help here, even though the solution was not given but it made me look at things in a way I would have not looked without getting the wonderful assistance here).

Thanks again and I wish all of you a wonderful day. grinhalo.gif

Leeann Christine Davidson

--------------------
Lee Ann Davidson
Go to the top of the page
 
DanielPineault
post Aug 16 2019, 07:00 PM
Post#6


UtterAccess VIP
Posts: 6,832
Joined: 30-June 11



Apparently Microsoft released a fix (KB4512494) today to address the issue, see: https://support.microsoft.com/en-us/help/45...pdate-kb4512494

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
PhilS
post Aug 17 2019, 05:03 AM
Post#7



Posts: 614
Joined: 26-May 15
From: The middle of Germany


QUOTE
Apparently Microsoft released a fix (KB4512494) today to address the issue ...

That's a start!
However, this fix seems to apply to Windows 10, Version 1709 only. There is no similar update for newer versions of Windows 10, let alone Windows 7 and 8, yet.

The oldest version of Windows 10 I've got still installed is version 1803 and there I get this message already:
QUOTE
You're currently running a version of Windows that's nearing the end of support. We recommend you update to the most recent version of Windows 10 now to get the latest features and security improvements.

In the light of the fix to this issue being only available for an even older version of Windows 10 this feels somewhat like mockery.
On the other hand, maybe they are just pushing a canary into the coal mine with this most recent update...

Well, criticism aside, it is very good news that Microsoft is actively working on this. Let's hope there will be similar fixes for other versions of Windows next week.

--------------------
Go to the top of the page
 
DanielPineault
post Aug 17 2019, 06:24 AM
Post#8


UtterAccess VIP
Posts: 6,832
Joined: 30-June 11



There's also this one for Windows 8.1 and Windows Server 2012 R2

https://support.microsoft.com/en-us/help/45...pdate-kb4517298

and there's this one for Windows 7 SP1 and Windows Server 2008 R2 SP1

https://support.microsoft.com/en-us/help/45...pdate-kb4517297


it's a nightmare to try and find them all, but for Windows 10, you seem to be right that only 1709 appears to have an update available to resolve the issue currently. very odd.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
PhilS
post Aug 17 2019, 08:14 AM
Post#9



Posts: 614
Joined: 26-May 15
From: The middle of Germany


QUOTE
and there's this one for Windows 7 SP1 and Windows Server 2008 R2 SP1

Great! - I didn't find that.
But they seem to have been in such a hurry, that they put a wrong link to the download into that article. Here is the correct one: http://www.catalog.update.microsoft.com/Se...spx?q=kb4517297

Edit:
I just installed the Windows 8.1 patch and it fixes all known incarnations of the issue.
This post has been edited by PhilS: Aug 17 2019, 08:16 AM

--------------------
Go to the top of the page
 
wrmosca
post Aug 20 2019, 09:18 AM
Post#10


UtterAccess VIP
Posts: 168
Joined: 20-July 03
From: San Francisco Bay Area


This is why I don't develop in Access anymore. I can't count on it to work. I've moved on to Epic healthcare systems. Bugs reported are corrected in days.

--------------------
Go to the top of the page
 
DanielPineault
post Aug 20 2019, 05:49 PM
Post#11


UtterAccess VIP
Posts: 6,832
Joined: 30-June 11



Hey Bill, what do you do about Windows 10?! shrug.gif


QUOTE
This is why I don't develop in Access anymore. I can't count on it to work.

I've lost one of my biggest clients due to continual issue with A2016-O365 and just finish migrating another client to a PHP based system to get away from the continual issues/downtime. I find myself pulled more and more towards anything other than Access because of all the issues whether it be Windows 10 or O365, there always seems to be something. I also find MS slow to even acknowledge issues, little alone fix them (with the exception of this current one). Where I waas doing 95% Access development, I now find myself doing maybe 35% in Access these days. It's sad and entirely Microsoft's own fault.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
wrmosca
post Aug 21 2019, 12:08 PM
Post#12


UtterAccess VIP
Posts: 168
Joined: 20-July 03
From: San Francisco Bay Area


Daniel - The only thing I use Windows for is to run PuTTY sessions to the Linux servers. And my employer and I are still on Windows 7.

--------------------
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    15th September 2019 - 09:21 PM