Forum Discussion
Windows update KB4484119 crash ms access, error 4430
Hello everyone, Yesterdey windows update deploy the KB4484119 update, this is making a no-sense error in ms access, error 4430: Query '' is corrupted
What we can do?, I uninstalled the KB4484119 update and the ms access works again, but the windows update will set it again and again in all the pcs, and now they cant use access properly
In blogs, people are talking about, and this error afects ms access 2010 and 2016 too
How long will take to windows to detect and solve this?
HELP ASAP
- cgentileCopper Contributor
LucasSerrano also all query UPDATE crash if is present KB4484127 for Office 2010, KB4484119 for Office 2013 and KB4484113 for Office 2016
It's a new bug caused by a series of flawed security updates. You can learn everything there is to know about the issue and possible workarounds by reading
https://www.devhut.net/2019/11/14/access-bug-error-3340-query-is-corrupt/
But basically, you need to look for and uninstall any and all of the following updates and then disable updates until this gets cleaned up by Microsoft (they are predicting December 10th):
- KB4484127
- KB4484119
- KB4484113
- KB3085368
If you can, send feedback through your app, call Microsoft Support to tell them this impacted your business, ...
- Derek_SturdyCopper Contributor
This is a significant pain, not least because, having released the damaging security update and then seen the havoc it caused, you might have expected that an immediate retracting update would have been issued. Still, the laborious and slow process, set out in the link mentioned above, does allow you to use Access again, although you will need to switch off all updates for at least two weeks to prevent the wretched bugs being bolted back into your system. Depending on the speed of your internet, allow at least an hour to carry out the procedure. By the way, when they ask you to use an "extended" command prompt, as part of the laborious procedure, that is just unnecessary jargon for "run as administrator". Advice: to save trouble - especially if it is a long time since you used DOS commands - when you are in the "command prompt" part, make sure that the new directory you create, into which you download the files from Microsoft, is in the root of C:\ - as in C:\FixStupidUpdates, for example? - it will save a lot of cd commands. And a final tip: it is not clearly stated, but the big download file is in fact a zip file, and once you have downloaded it to your new directory (C:\FixStupidUpdates in my example), click the .exe in order to unzip the files. You can do this from Windows Explorer - you do not need to be at a DOS [prompt for that job.
- Derek_SturdyCopper Contributor
by the way: http://fmsinc.com/MicrosoftAccess/Errors/query_is_corrupt/ gives the clearest instructions, that I found. Bless their hearts for taking the trouble.