{"id":11963,"date":"2019-11-19T10:05:33","date_gmt":"2019-11-19T09:05:33","guid":{"rendered":"http:\/\/159.69.82.204\/win\/?p=11963"},"modified":"2019-11-23T20:02:51","modified_gmt":"2019-11-23T19:02:51","slug":"fix-for-error-3340-in-access-2016-update-kb4484198","status":"publish","type":"post","link":"https:\/\/borncity.com\/win\/2019\/11\/19\/fix-for-error-3340-in-access-2016-update-kb4484198\/","title":{"rendered":"Fix for Error 3340 in Access 2016 (Update KB4484198)"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" style=\"float: left; margin: 0px 10px 0px 0px; display: inline; border-width: 0px;\" title=\"Update\" src=\"https:\/\/www.borncity.com\/blog\/wp-content\/uploads\/2015\/02\/Update.jpg\" alt=\"Windows Update\" width=\"54\" height=\"54\" align=\"left\" border=\"0\" \/>[<a href=\"https:\/\/www.borncity.com\/blog\/2019\/11\/19\/fix-fr-fehler-3340-in-access-2016-update-kb4484198\/\" target=\"_blank\" rel=\"noopener noreferrer\">German<\/a>]On November 18, 2019, Microsoft released update KB4484198 to fix error 3340 with database accesses in Access 2016. Further fixes for other Access versions will follow soon. Addendum: Also Click to Run Access 2016 has been fixed via an update.<\/p>\n<p><!--more--><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/vg01.met.vgwort.de\/na\/6938b337f1124bc1b9678bb17e51a516\" alt=\"\" width=\"1\" height=\"1\" \/>I had already noticed it the night before via a tweet from Woody Leonhard, but German blog reader Peter Doering also left a <a href=\"https:\/\/www.borncity.com\/blog\/2019\/11\/13\/access-fehler-3340-durch-november-2019-updates\/#comment-80689\" target=\"_blank\" rel=\"noopener noreferrer\">corresponding comment<\/a>.<\/p>\n<blockquote class=\"twitter-tweet\">\n<p dir=\"ltr\" lang=\"en\">Remember how Microsoft said there would be no \"C\" or \"D\" week patches in November or December? Looks like we have a Friday \"C\" week patch coming to fix the bug in Access introduced by this month's Patch Tuesday CVE-2019-1402 fix. <a href=\"https:\/\/t.co\/gxohl8FqED\">https:\/\/t.co\/gxohl8FqED<\/a> Thx <a href=\"https:\/\/twitter.com\/hashtag\/PatchLady?src=hash&amp;ref_src=twsrc%5Etfw\">#PatchLady<\/a> <a href=\"https:\/\/twitter.com\/SBSDiva?ref_src=twsrc%5Etfw\">@SBSDiva<\/a><\/p>\n<p>\u2014 Woody Leonhard (@AskWoody) <a href=\"https:\/\/twitter.com\/AskWoody\/status\/1196536763944198144?ref_src=twsrc%5Etfw\">November 18, 2019<\/a><\/p><\/blockquote>\n<p><span id=\"preserve8a625abe2517417788d68bfbd14aa751\" class=\"wlWriterPreserve\"><script src=\"https:\/\/platform.twitter.com\/widgets.js\" async=\"\" charset=\"utf-8\"><\/script><\/span><\/p>\n<h2>What's the problem?<\/h2>\n<p>Updates released for Microsoft Office for Patchday (November 12, 2019) cause Access to issue an error '3340: Query \"|\" is corrupted\" when accessing databases with a query.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"3340: Query \"|\" is corrupt\" src=\"https:\/\/support.content.office.net\/en-us\/media\/cfa97846-d77d-4416-84e7-e9fe8180d2ed.png\" alt=\"3340: Query \"|\" is corrupt\" width=\"393\" height=\"202\" \/>(English Error Message)<\/p>\n<p>The error occurs in all Access versions, with MSI and C2R installation as well as in the Access runtime. I had discussed the details in the blog post <a href=\"https:\/\/borncity.com\/win\/2019\/11\/13\/office-november-2019-updates-are-causing-access-error-3340\/\">Office November 2019 Updates are causing Access Error 3340<\/a>. Microsoft had announced a fix for November 24th (for Click-2-Run installations) and for the remaining Access variants for December 10, 2019. .<\/p>\n<h2>Hotfix KB4484198 for Access 2016<\/h2>\n<p>On November 18, 2019 Microsoft surprisingly released the update <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/4484198\/november-18-2019-update-for-office-2016-kb4484198\" target=\"_blank\" rel=\"noopener noreferrer\">KB4484198<\/a> (November 18, 2019, update for Office 2016). The support article says about the improvements and bug fixes:<\/p>\n<blockquote><p>This update fixes the following issue:<\/p>\n<p>After you install update <a href=\"https:\/\/support.microsoft.com\/help\/3085368\" target=\"_blank\" rel=\"noopener noreferrer\">3085368<\/a> or <a href=\"https:\/\/support.microsoft.com\/help\/4484113\" target=\"_blank\" rel=\"noopener noreferrer\">4484113<\/a>, you may receive the following error message when you try to run an Update query in Microsoft Access: Query \"query name\" is corrupt.<\/p><\/blockquote>\n<p>So the error described above in Microsoft Access 2016 (MSI installation) is fixed. This update is provided by Microsoft as a hotfix through the Download Center. Here are the download links:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.microsoft.com\/download\/details.aspx?familyid=d71c0dd8-c092-4e6a-b92f-339d0b56104a\" target=\"_blank\" rel=\"noopener noreferrer\">Update KB4484198 32-Bit Version (Office 2016)<\/a><\/li>\n<li><a href=\"http:\/\/www.microsoft.com\/download\/details.aspx?familyid=db6cabbb-44c0-4e25-af1a-c8b21656d32f\" target=\"_blank\" rel=\"noopener noreferrer\">Update KB4484198 64-Bit Version (Office 2016)<\/a><\/li>\n<\/ul>\n<p>The update requires an installed Microsoft Office 2016 and a restart is required after the update. As a precaution, Microsoft provides instructions on how to uninstall the update in the KB article.<\/p>\n<h3>Click-2-Run Access 2016 also fixed<\/h3>\n<p><strong>Addendum:<\/strong> According to <a href=\"https:\/\/www.borncity.com\/blog\/2019\/11\/19\/fix-fr-fehler-3340-in-access-2016-update-kb4484198\/#comment-80697\" target=\"_blank\" rel=\"noopener noreferrer\">this German comment<\/a> Click-to-Run Access 2016 (from a MS Office 2016 Pro Plus) has been fixed via an update to Build 12130.20390 (just initiate an update search).<\/p>\n<blockquote><p>I currently don't have any Office environments with Access installed because I don't need it. Can someone with Access 2016 who is affected by the error test whether the update KB4484198 corrects the error?<\/p><\/blockquote>\n<h2>Timetable for further fixes<\/h2>\n<p>The pressure on Microsoft to soon fix the bug in Access and not wait until December 10, 2019 must have been immense &#8211; in some companies part of the infrastructure was down because applications depended on these Access database accesses. In any case, Microsoft has drastically adjusted its timetable for fixes of this error.<\/p>\n<table id=\"tblID0EQACAAA\" class=\"banded flipColors\">\n<thead>\n<tr>\n<th>Version<\/th>\n<th>Build<\/th>\n<th>Release Date<\/th>\n<th>Update Link<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Access 2010<\/td>\n<td>7241.5001<\/td>\n<td>November 22, 2019 (estimated)<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Access 2013<\/td>\n<td>5189.1002<\/td>\n<td>November 22, 2019 (estimated)<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Access 2016 MSI<\/td>\n<td>4927.1002<\/td>\n<td>November 18, 2019<\/td>\n<td><a href=\"https:\/\/support.microsoft.com\/help\/4484198\" target=\"_blank\" rel=\"noopener noreferrer\">KB4484198<\/a><\/td>\n<\/tr>\n<tr>\n<td>Access 2019 Volume License<\/td>\n<td>10352.20054<\/td>\n<td>December 10, 2019<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Access for Office 365\/Access 2016 C2R\/Access 2019 (Version 1911)<\/td>\n<td>12228.20152<\/td>\n<td>November 22, 2019 (estimated)<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Access for Office 365 Semi-Annual (1901)<\/td>\n<td><\/td>\n<td>November 25, 2019 (estimated)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>According to <a href=\"https:\/\/support.office.com\/en-us\/article\/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec\" target=\"_blank\" rel=\"noopener noreferrer\">this Microsoft article<\/a>, which is dealing with the issue, the new dates outlined within the above table are promising some fixes for this week (previously fixes has been announded for November 24, and Dezember 10, 2019).<\/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>\n<p><strong>Similar articles<\/strong><br \/>\n<a href=\"https:\/\/borncity.com\/win\/2019\/11\/06\/microsoft-office-patchday-november-5-2019\/\">Microsoft Office Patchday (November 5, 2019)<\/a><br \/>\n<a href=\"https:\/\/borncity.com\/win\/2019\/11\/13\/microsoft-security-update-summary-november-12-2019\/\">Microsoft Security Update Summary (November 12, 2019)<\/a><br \/>\n<a href=\"https:\/\/borncity.com\/win\/2019\/11\/13\/patchday-updates-for-windows-7-8-1-server-nov-12-2019\/\">Patchday: Updates for Windows 7\/8.1\/Server (Nov. 12, 2019)<\/a><br \/>\n<a href=\"https:\/\/borncity.com\/win\/2019\/11\/13\/patchday-windows-10-updates-november-12-2019\/\">Patchday Windows 10 Updates (November 12, 2019)<\/a><br \/>\n<a href=\"https:\/\/borncity.com\/win\/2019\/11\/14\/patchday-microsoft-office-updates-november-12-2019\/\">Patchday Microsoft Office Updates (November 12, 2019)<\/a><br \/>\n<a href=\"https:\/\/borncity.com\/win\/2019\/11\/13\/office-november-2019-updates-are-causing-access-error-3340\/\">Office November 2019 Updates are causing Access Error 3340<\/a><br \/>\n<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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[German]On November 18, 2019, Microsoft released update KB4484198 to fix error 3340 with database accesses in Access 2016. Further fixes for other Access versions will follow soon. Addendum: Also Click to Run Access 2016 has been fixed via an update.<\/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":[1782,399,2188,195],"class_list":["post-11963","post","type-post","status-publish","format-standard","hentry","category-issue","category-office","category-update","tag-access","tag-fix","tag-kb4484198","tag-update"],"_links":{"self":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/11963","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=11963"}],"version-history":[{"count":0,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/11963\/revisions"}],"wp:attachment":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/media?parent=11963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/categories?post=11963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/tags?post=11963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}