{"id":22620,"date":"2021-12-17T00:11:00","date_gmt":"2021-12-16T23:11:00","guid":{"rendered":"http:\/\/159.69.82.204\/win\/?p=22620"},"modified":"2021-12-17T10:11:27","modified_gmt":"2021-12-17T09:11:27","slug":"microsoft-besttigte-probleme-in-allen-access-versionen-nach-dezember-2021-update","status":"publish","type":"post","link":"https:\/\/borncity.com\/win\/2021\/12\/17\/microsoft-besttigte-probleme-in-allen-access-versionen-nach-dezember-2021-update\/","title":{"rendered":"Microsoft confirms issues in all Access versions after December 2021 Update"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" style=\"float: left; margin: 0px 10px 0px 0px; display: inline;\" src=\"https:\/\/www.borncity.com\/blog\/wp-content\/uploads\/2012\/07\/Office1.jpg\" width=\"55\" height=\"60\" align=\"left\" \/>[<a href=\"https:\/\/www.borncity.com\/blog\/?p=260632\" target=\"_blank\" rel=\"noopener\">German<\/a>]The December 14, 2021 security updates for Microsoft Office (MSI installer version) cause issues with Microsoft Access. Only one user can still access the databases. In the meantime it is clear that the Click-2-Run versions of Office\/Access are also affected by updates. Microsoft has confirmed the problems in the meantime, so I give a short overview again.<\/p>\n<p><!--more--><\/p>\n<h2>Fix for CVE-2021-42293 causes problems<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/vg01.met.vgwort.de\/na\/ddcfc9c7f37f4fc5ba70df8e2c7badda\" alt=\"\" width=\"1\" height=\"1\" \/>CVE-2021-42293 describes a vulnerability in the Microsoft Jet Red Database Engine and in the Access Connectivity Engine. This vulnerability allows elevation of privilege. However, Microsoft rates the exploitability of the vulnerability as low probability.<\/p>\n<ul>\n<li>Microsoft patched the vulnerability as of December 14, 2021 for the MSI versions of Microsoft Office 2013 and 2016 through updates <a href=\"https:\/\/support.microsoft.com\/help\/5002104\" target=\"_blank\" rel=\"noopener\">KB5002104<\/a> (Office 2013) and <a href=\"https:\/\/support.microsoft.com\/help\/5002099\" target=\"_blank\" rel=\"noopener\">KB5002099<\/a> (Office 2016).<\/li>\n<li>For the Click-2-Run versions of Microsoft 365, Microsoft Office 2019 and Microsoft Office LTSC 2021, on the other hand, a Click-to-Run update with corresponding fixes was rolled out &#8211; there are no individual updates.<\/li>\n<\/ul>\n<p>In the blog post <a href=\"https:\/\/borncity.com\/win\/2021\/12\/15\/patchday-microsoft-office-dezember-2021-updates-14-12-2021-verursacht-access-probleme\/\">Patchday: Microsoft Office December 2021 updates (14.12.2021) causes Access issues<\/a>, I had indeed pointed out that the two updates listed above affect access to Access databases. This is because German blog readers have <a href=\"https:\/\/www.borncity.com\/blog\/2021\/12\/15\/microsoft-security-update-summary-14-dezember-2021\/#comment-118624\" target=\"_blank\" rel=\"noopener\">reported on the blog<\/a> that they are having problems with the Access engine after installing the update.<\/p>\n<blockquote><p>MS Access does not work anymore. Databases can now only be edited by one person at a time.<\/p><\/blockquote>\n<p>The error was confirmed by other blog readers. Other GErman users had <a href=\"https:\/\/www.borncity.com\/blog\/2021\/12\/15\/patchday-windows-10-updates-14-dezember-2021\/#comment-118758\" target=\"_blank\" rel=\"noopener\">left comments<\/a> on the blog as shown below. <a href=\"https:\/\/www.borncity.com\/blog\/2021\/12\/15\/patchday-windows-10-updates-14-dezember-2021\/#comment-118758\">Kommentare<\/a><\/p>\n<blockquote><p>We have had a problem with Access databases not working in multi-user access for some customers since the Windows update. The \"file could not be locked.\" In other words shared access to Access databases is no longer possible.<\/p><\/blockquote>\n<p>This also affects Access 2013\/2016 Runtime, which is used by some users.<\/p>\n<h2>Click2Run variants also affected<\/h2>\n<p>Within this German <a href=\"https:\/\/www.borncity.com\/blog\/2021\/12\/15\/patchday-microsoft-office-dezember-2021-updates-14-12-2021-verursacht-access-probleme\/#comment-118648\" target=\"_blank\" rel=\"noopener\">comment<\/a> then a German user asked if Access from Office 2019\/2021 and 365 was also affected. I had negated this, referring to the two updates mentioned above. The background is that Office 2019\/2021 and 365 are installed as a Click2Run solution and do not receive security updates via Windows Update on Patchday (2nd Tuesday of the month).<\/p>\n<p>For the Click2Run versions of Microsoft Office (Microsoft 365 Apps for enterprise, Microsoft 365 Apps for business, Office 2016 Retail (C2R), Office 2019, Office LTSC 2021, Office 2021), there was <a href=\"https:\/\/docs.microsoft.com\/en-us\/officeupdates\/microsoft365-apps-security-updates\" target=\"_blank\" rel=\"noopener\">an update<\/a> of the entire Office package to the following builds on December 14, 2021:<\/p>\n<blockquote><p>Current Channel: Version 2111 (Build 14701.20248)<br \/>\nMonthly Enterprise Channel: Version 2110 (Build 14527.20340)<br \/>\nMonthly Enterprise Channel: Version 2109 (Build 14430.20380)<br \/>\nSemi-Annual Enterprise Channel (Preview): Version 2108 (Build 14326.20692)<br \/>\nSemi-Annual Enterprise Channel: Version 2102 (Build 13801.21086)<br \/>\nSemi-Annual Enterprise Channel: Version 2008 (Build 13127.21842)<br \/>\nOffice 2021 Retail: Version 2111 (Build 14701.20248)<br \/>\nOffice 2019 Retail: Version 2111 (Build 14701.20248)<br \/>\nOffice 2016 Retail: Version 2111 (Build 14701.20248)<br \/>\nOffice LTSC 2021 Volume Licensed: Version 2108 (Build 14332.20204)<br \/>\nOffice 2019 Volume Licensed: Version 1808 (Build 10381.20020)<\/p><\/blockquote>\n<p>Hier im Blog wurde daher kurze Zeit nach der Frage aus der Leserschaft des Blogs <a href=\"https:\/\/www.borncity.com\/blog\/2021\/12\/15\/patchday-microsoft-office-dezember-2021-updates-14-12-2021-verursacht-access-probleme\/#comment-118688\">best\u00e4tigt<\/a>, dass auch die Click2Run-Varianten nach einer Aktualisierung von diesem Bug\u00a0 betroffen sind.<\/p>\n<h2>Microsoft confirms the issues<\/h2>\n<p>Based on the initial feedback, I then informed Microsoft via Twitter and referred to the English-language blog post of mine. A short time later, Microsoft then added the following entry to the support posts for <a href=\"https:\/\/support.microsoft.com\/help\/5002104\" target=\"_blank\" rel=\"noopener\">KB5002104<\/a> (Office 2013) and <a href=\"https:\/\/support.microsoft.com\/help\/5002099\" target=\"_blank\" rel=\"noopener\">KB5002099<\/a> (Office 2016).<\/p>\n<blockquote><p>After this update is installed, databases that are stored on a network share can't be accessed by multiple users simultaneously. Microsoft is aware of this issue and will update this KB when a fix is available.<\/p><\/blockquote>\n<p>The only remedy in these two cases is to uninstall the above-mentioned security updates <a href=\"https:\/\/support.microsoft.com\/help\/5002104\" target=\"_blank\" rel=\"noopener\">KB5002104<\/a> (Office 2013) and <a href=\"https:\/\/support.microsoft.com\/help\/5002099\" target=\"_blank\" rel=\"noopener\">KB5002099<\/a> (Office 2016). Heinrich Moser gives the following command for the updates of the Click2Run versions of Microsoft Office (Office 365\/2016 C2R\/2019) distributed on December 14, 2021 in the Current Channel in <a href=\"https:\/\/www.borncity.com\/blog\/2021\/12\/15\/patchday-microsoft-office-dezember-2021-updates-14-12-2021-verursacht-access-probleme\/#comment-118743\" target=\"_blank\" rel=\"noopener\">this German comment<\/a> to reinstall the previous version:<\/p>\n<pre>\"C:\\Program Files\\Common Files\\microsoft shared\\ClickToRun\\OfficeC2RClient.exe\" \/update user updatetoversion=16.0.14701.20226<\/pre>\n<p>This is the build rolled out on December 3, 2021 (<a href=\"https:\/\/docs.microsoft.com\/en-us\/officeupdates\/current-channel\" target=\"_blank\" rel=\"noopener\">see<\/a>). It is not necessary to restart the machines. On Microsoft Answers there is also <a href=\"https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/could-not-lock-file-with-access-build-1470120248\/f2b26fe5-6e86-40bc-a469-464c3898df15\" target=\"_blank\" rel=\"noopener\">this thread<\/a> on the subject. MVP Daniel Pineault has also published a post <a href=\"https:\/\/www.devhut.net\/access-lock-file-issues\/\" target=\"_blank\" rel=\"noopener\">here<\/a> with corresponding references.<\/p>\n<p><strong>Addendum:<\/strong> Shortly after writing this article, Microsoft has released\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/officeupdates\/current-channel\" target=\"_blank\" rel=\"noopener\">Version 2111: December 16<\/a> <em>Build 14701.20262 <\/em>and wrote:<\/p>\n<blockquote><p>This update fixes an issue that would prevent multiple users from opening a database on a network file share.<\/p><\/blockquote>\n<p>But <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/error-in-access-when-opening-a-database-on-a-network-file-share-6cbc1560-62c2-46e7-9980-d079a46f5acc\" target=\"_blank\" rel=\"noopener\">this support article<\/a> hasn't been updated till yet.<\/p>\n<p><strong>Similar articles:<br \/>\n<\/strong><a href=\"https:\/\/borncity.com\/win\/2021\/12\/09\/microsoft-office-patchday-7-dezember-2021\/\">Microsoft Office Patchday (December 7, 2021)<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/09\/microsoft-office-patchday-7-dezember-2021\/\"><br \/>\n<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/15\/microsoft-security-update-summary-14-dezember-2021\/\">Microsoft Security Update Summary (December 14, 2021)<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/09\/microsoft-office-patchday-7-dezember-2021\/\"><br \/>\n<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/15\/patchday-windows-10-updates-december-14-2021\/\">Patchday: Windows 10 Updates (December 14, 2021)<\/a><a href=\"https:\/\/www.borncity.com\/blog\/2021\/12\/15\/patchday-windows-10-updates-14-dezember-2021\/\">)<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/09\/microsoft-office-patchday-7-dezember-2021\/\"><br \/>\n<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/15\/patchday-windows-11-updates-14-dezember-2021\/\">Patchday: Windows 11-Updates (December 14, 2021)<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/09\/microsoft-office-patchday-7-dezember-2021\/\"><br \/>\n<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/15\/patchday-windows-8-1-server-2012-updates-14-dezember-2021\/\">Patchday: Windows 8.1\/Server 2012-Updates (December 14, 2021)<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/09\/microsoft-office-patchday-7-dezember-2021\/\"><br \/>\n<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/15\/patchday-updates-fr-windows-7-server-2008-r2-dezember-14-2021\/\">Patchday: Updates f\u00fcr Windows 7\/Server 2008 R2 (December 14, 2021)<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/09\/microsoft-office-patchday-7-dezember-2021\/\"><br \/>\n<\/a><a href=\"https:\/\/borncity.com\/win\/2021\/12\/15\/patchday-microsoft-office-dezember-2021-updates-14-12-2021-verursacht-access-probleme\/\">Patchday: Microsoft Office December 2021 updates (14.12.2021) causes Access issues<\/a><br \/>\n<a href=\"https:\/\/borncity.com\/win\/2021\/12\/16\/update-fixt-windows-appx-installer-0-day-schwachstelle-cve-2021-43890-emotet-schlupfloch\/\">Update fixes Windows AppX installer 0-day vulnerability CVE-2021-43890 (used by Emotet)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[German]The December 14, 2021 security updates for Microsoft Office (MSI installer version) cause issues with Microsoft Access. Only one user can still access the databases. In the meantime it is clear that the Click-2-Run versions of Office\/Access are also affected &hellip; <a href=\"https:\/\/borncity.com\/win\/2021\/12\/17\/microsoft-besttigte-probleme-in-allen-access-versionen-nach-dezember-2021-update\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[463,11,22],"tags":[1782,166,125,2696,195],"class_list":["post-22620","post","type-post","status-publish","format-standard","hentry","category-issue","category-office","category-update","tag-access","tag-issues","tag-office","tag-patchday-12-2021","tag-update"],"_links":{"self":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/22620","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=22620"}],"version-history":[{"count":0,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/22620\/revisions"}],"wp:attachment":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/media?parent=22620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/categories?post=22620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/tags?post=22620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}