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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V  1 2 >  (Go to first unread post)
   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: 651
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: 7,008
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, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://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: 36,181
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 did business for 20 years.
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: 7,008
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, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://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,291
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: 7,008
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, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://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: 651
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: 7,008
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, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://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: 651
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: 7,008
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, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://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
 
SemiAuto40
post Oct 8 2019, 09:02 AM
Post#13



Posts: 706
Joined: 3-April 12
From: L.A. (lower Alabama)


What may I ask is the other 65% development in?
Go to the top of the page
 
Lewis-H
post Nov 7 2019, 03:27 AM
Post#14


Utterly Banned Spammer
Posts: 3
Joined: 7-November 19



I encountered two different, although related, scenarios were the “Invalid procedure call or argument” error occurs due to the installed update. Both are related to empty arrays. can anyone tell me what are they?

Regards,
Lewis
Go to the top of the page
 
PhilS
post Nov 7 2019, 04:16 AM
Post#15



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


QUOTE
I encountered two different, although related, scenarios were the “Invalid procedure call or argument” error occurs due to the installed update. Both are related to empty arrays. can anyone tell me what are they?

The first two sentences are a quote from my text on that problem. The explanation what those scenarios are follows immediately after those sentences.


--------------------
Go to the top of the page
 
RCollard
post Nov 13 2019, 12:14 PM
Post#16



Posts: 86
Joined: 21-May 08
From: Wyoming


And Windows update strikes again! We have gotten a half dozen reports of "query is corrupted" errors in the last two hours. See

Patch Tuesday arrives with Access error and

Office November 2019 Updates are causing Access Error 3340

--------------------
Rick
Go to the top of the page
 
RCollard
post Nov 13 2019, 12:31 PM
Post#17



Posts: 86
Joined: 21-May 08
From: Wyoming


Official fix is a month away?

Access error: "Query is corrupt"

--------------------
Rick
Go to the top of the page
 
isladogs
post Nov 13 2019, 12:31 PM
Post#18


UtterAccess VIP
Posts: 1,893
Joined: 4-June 18
From: Somerset, UK


I'm having problems with both links in post #16.
They appear briefly and disappear again followed by a message 'This page is having trouble loading.
Do the links work OK for other people?

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
GroverParkGeorge
post Nov 13 2019, 01:10 PM
Post#19


UA Admin
Posts: 36,181
Joined: 20-June 02
From: Newcastle, WA


Yes, they both loaded for me.

Maybe you are a victim of the bug? (just kidding)

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
theDBguy
post Nov 13 2019, 01:15 PM
Post#20


UA Moderator
Posts: 76,866
Joined: 19-June 07
From: SunnySandyEggo


Hi. The links worked for me too. Cheers!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
2 Pages V  1 2 >


Custom Search


RSSSearch   Top   Lo-Fi    11th December 2019 - 04:19 AM