{"id":11864,"date":"2019-11-13T11:18:12","date_gmt":"2019-11-13T10:18:12","guid":{"rendered":"http:\/\/159.69.82.204\/win\/?p=11864"},"modified":"2024-10-03T00:44:29","modified_gmt":"2024-10-02T22:44:29","slug":"office-november-2019-updates-are-causing-access-error-3340","status":"publish","type":"post","link":"https:\/\/borncity.com\/win\/2019\/11\/13\/office-november-2019-updates-are-causing-access-error-3340\/","title":{"rendered":"Office November 2019 Updates are causing Access Error 3340"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" style=\"float: left; margin: 0px 10px 0px 0px; display: inline;\" src=\"http:\/\/www.borncity.com\/blog\/wp-content\/uploads\/2012\/07\/Office1.jpg\" width=\"55\" height=\"60\" \/>[<a href=\"https:\/\/www.borncity.com\/blog\/2019\/11\/13\/access-fehler-3340-durch-november-2019-updates\/\" target=\"_blank\" rel=\"noopener noreferrer\">German<\/a>]Microsoft Office security updates released on Patchday (November 12, 2019) cause Access to fail to access databases. An error 3340 'Query is corrupted' will be dropped. <strong>Addendum:<\/strong> I reported the issue to Microsoft, a fix is in preparation &#8211; see inside. <strong>Addendum 2:<\/strong> A fix for Access 2016 is available.<\/p>\n<p><!--more--><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/vg07.met.vgwort.de\/na\/9d01abc758ad4d17997be46b1a471e36\" alt=\"\" width=\"1\" height=\"1\" \/>or a list of updates released for November 2019 for the MSI versions of Microsoft Office, see <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/4527848\/november-2019-updates-for-microsoft-office\" target=\"_blank\" rel=\"noopener noreferrer\">this Microsoft page<\/a>.<\/p>\n<h2>Error 3340: \"Query\" is corrupted<\/h2>\n<p>Within my German blog I got this night the first comments from blog readers claiming an issue with Access, after installing Office security updates released on November 12, 2019.<\/p>\n<h3>Report #1: Error in Access 2010<\/h3>\n<p>German blog reader <a href=\"https:\/\/www.borncity.com\/blog\/2019\/11\/13\/microsoft-security-update-summary-12-november-2019\/#comment-80357\" target=\"_blank\" rel=\"noopener noreferrer\">Ollat wrotes<\/a> with reference to the Access 2010 he uses, the following:<\/p>\n<blockquote><p>Again something seems to have changed when accessing Access databases, this time Access 2010.<\/p>\n<p>There was a similar problem last with 97'er DBs<\/p>\n<p>Uninstalling Office 2010 Security Update seems to help the first customers.<\/p><\/blockquote>\n<p>This concerns Microsoft Access 2010 in a specific case &#8211; uninstalling Office 2010 Security Update <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/4484127\/security-update-for-office-2010-november-12-2019\" target=\"_blank\" rel=\"noopener noreferrer\">KB4484127<\/a> fixed the error.<\/p>\n<h3>Error in Access 2010, 2013, and 2016<\/h3>\n<p>At the same time I received a message from Annette via e-mail reparting the same issue with Access. She wrote (I've translated the German texts within this English blog post):<\/p>\n<blockquote><p>Do you already have information about the updates from 13.11.2019? I have received some messages that Access reports \"3340 query is corrupted\". I guess it concerns Office 2013 but I'm not sure.<\/p>\n<p>What's certain is that it's not the database, it must be a bug that was introduced with the update..<\/p><\/blockquote>\n<p>She supposed that Office 2013 and its Access version is affected. But later Annette left <a href=\"https:\/\/www.borncity.com\/blog\/2019\/11\/13\/microsoft-security-update-summary-12-november-2019\/#comment-80363\" target=\"_blank\" rel=\"noopener noreferrer\">another comment<\/a> with further information:<\/p>\n<blockquote><p>if I just thought it concerns Office 2013, I now know that Office 2010 and 2016 are also affected.<\/p><\/blockquote>\n<p>At German site administrator.de there is <a href=\"https:\/\/administrator.de\/forum\/abfrage-besch%C3%A4digt-error-code-3340-access2013-514571.html\" target=\"_blank\" rel=\"noopener noreferrer\">this thread<\/a>, where the Access error has been discussed also. Addendum: There are now also threads at Technet forum here and here.<\/p>\n<h2>Workaround: Uninstall Office security update<\/h2>\n<p>It appears that a security update for the <a href=\"https:\/\/portal.msrc.microsoft.com\/en-US\/security-guidance\/advisory\/CVE-2019-1402\" target=\"_blank\" rel=\"noopener noreferrer\">CVE-2019-1402<\/a> vulnerability in each version of Microsoft Office causes this error. Here is the list of Office security updates that you can uninstall.<\/p>\n<ul>\n<li>Office 2010: <a href=\"https:\/\/support.microsoft.com\/help\/4484127\" target=\"_blank\" rel=\"noopener noreferrer\">Description of the security update for Office 2010: November 12, 2019 (KB4484127)<\/a><\/li>\n<li>Office 2013: <a href=\"https:\/\/support.microsoft.com\/help\/4484119\" target=\"_blank\" rel=\"noopener noreferrer\">Description of the security update for Office 2013: November 12, 2019 (KB4484119)<\/a><\/li>\n<li>Office 2016: <a href=\"https:\/\/support.microsoft.com\/help\/4484113\" target=\"_blank\" rel=\"noopener noreferrer\">Description of the security update for Office 2016: November 12, 2019 (KB4484113)<\/a><\/li>\n<\/ul>\n<p>At least from what I've seen so far, uninstalling this security update seems to allow database access again. See also my addendum at the article's end &#8211; Microsoft will ship a fix and propose a workaround.<\/p>\n<h2>Addendum: Uninstalling the updates<\/h2>\n<p>Because it has been asked on both (German, English) blog posts, how to uninstall the update and prevent from reinstalling, here are some hints.<\/p>\n<ul>\n<li>Microsoft has provided the support article <a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/troubleshoot\/office\/ability-to-uninstall-office\" target=\"_blank\" rel=\"noopener noreferrer\">Information about the ability to uninstall Office updates<\/a>. This works for Updates shipped for MSI installs.<\/li>\n<li>If you use Office 2019 or Office 365, try the hints given within the support article\u00a0<a href=\"https:\/\/support.microsoft.com\/en-us\/help\/2770432\/how-to-revert-to-an-earlier-version-of-office-2013-or-office-2016-clic\" target=\"_blank\" rel=\"noopener noreferrer\">How to revert to an earlier version of Office 2016 Click-to-Run<\/a>.<\/li>\n<\/ul>\n<p>In Windows 7\/8.1 go back to Windows Update window and use the context menu to hide the problematic update package for further installs (if you have automatic update installation enabled, change the settings to 'ask for update installation'). If you are using Windows 10 and may prevent Windows Update from re-installing uninstalled updates, try to block the update using <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/3073930\/how-to-temporarily-prevent-a-driver-update-from-reinstalling-in-window\" target=\"_blank\" rel=\"noopener noreferrer\">wushowhide.diagcab<\/a> (hope that works, I've never tested it). Another option may be the 'defere updates' option in Windows 10.<\/p>\n<blockquote><p>I'll see if I can get this reported to Microsoft. Addendum: I have reported the issue to US Microsoft support. There was the case number and the promise to take care of it.<\/p>\n<p><strong>Addendum:<\/strong> There is now a <a href=\"https:\/\/support.office.com\/en-us\/article\/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec\" target=\"_blank\" rel=\"noopener noreferrer\">support article from Microsoft<\/a> dealing with that &#8211; a fix is in progress and they propose a workaround.<\/p>\n<p><strong>Addenum 2:<\/strong> A fix for Access 2016 is available &#8211; read the details at <a href=\"https:\/\/borncity.com\/win\/2019\/11\/19\/fix-for-error-3340-in-access-2016-update-kb4484198\/\">Fix for Error 3340 in Access 2016 (Update KB4484198)<\/a><\/p>\n<p><strong>Addendum 3:<\/strong> There is a new article\u00a0<a href=\"https:\/\/borncity.com\/win\/2019\/11\/23\/addendum-fixes-for-access-error-3340-nov-22-2019\/\" rel=\"bookmark\">Addendum: Fixes for Access Error 3340 (Nov. 22, 2019)<\/a> with additional information.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>[German]Microsoft Office security updates released on Patchday (November 12, 2019) cause Access to fail to access databases. An error 3340 'Query is corrupted' will be dropped. Addendum: I reported the issue to Microsoft, a fix is in preparation &#8211; see &hellip; <a href=\"https:\/\/borncity.com\/win\/2019\/11\/13\/office-november-2019-updates-are-causing-access-error-3340\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[463,11,22],"tags":[],"class_list":["post-11864","post","type-post","status-publish","format-standard","hentry","category-issue","category-office","category-update"],"_links":{"self":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/11864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/comments?post=11864"}],"version-history":[{"count":2,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/11864\/revisions"}],"predecessor-version":[{"id":35406,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/11864\/revisions\/35406"}],"wp:attachment":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/media?parent=11864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/categories?post=11864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/tags?post=11864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}