{"id":4180,"date":"2017-11-04T01:24:00","date_gmt":"2017-11-04T00:24:00","guid":{"rendered":"http:\/\/borncity.com\/win\/?p=4180"},"modified":"2024-10-05T19:00:58","modified_gmt":"2024-10-05T17:00:58","slug":"microsoft-tries-to-fix-the-jet-database-engine-bug","status":"publish","type":"post","link":"https:\/\/borncity.com\/win\/2017\/11\/04\/microsoft-tries-to-fix-the-jet-database-engine-bug\/","title":{"rendered":"Microsoft tries to fix the JET Database Engine bug"},"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\/2013\/03\/winb.jpg\" width=\"58\" height=\"58\" align=\"left\" \/>[<a href=\"http:\/\/www.borncity.com\/blog\/2017\/11\/03\/fix-fr-den-microsoft-jet-database-engine-bug\/\" target=\"_blank\" rel=\"noopener\">German<\/a>]Microsoft released a fix for the Microsoft JET Database Engine bug on November 2, 2017. This update fixes the problem with the Access or Excel database connection, but not in all versions of Windows. Here are some details about the topic.<\/p>\n<p><!--more--><\/p>\n<h2>The Background<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ssl-vg03.met.vgwort.de\/na\/864f2c3468ae46e8b7a079cbecfd5da9\" alt=\"\" width=\"1\" height=\"1\" \/>There was a buffer overflow vulnerability in the Microsoft JET Database Engine that allowed a remote code execution attack. The attacker was able to install programs, view, modify or delete data, and create new accounts with full user privileges. However, users whose user accounts are configured to work with default permissions were less likely to be affected than users with administrator privileges.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ssl-vg03.met.vgwort.de\/na\/ce5e5a4e3da44596b271253191e25eea\" alt=\"\" width=\"1\" height=\"1\" \/>Microsoft has detailed this vulnerability in Security Advisory <a href=\"https:\/\/portal.msrc.microsoft.com\/en-us\/security-guidance\/advisory\/CVE-2017-0250\" target=\"_blank\" rel=\"noopener\">CVE-2017-0250<\/a> (last revision October 10, 2017). In August 2017 Microsoft releases some security updates for some Windows version to close this vulnerability (see <a href=\"https:\/\/borncity.com\/win\/2017\/08\/09\/patchday-august-2017-updates-for-windows-78-1\/\">Patchday August 2017: Updates for Windows 7\/8.1<\/a>).<\/p>\n<h2>Issues since October 2017 patchday<\/h2>\n<p>On October 10, 2017 Microsoft released another patch, that causes issues. I received <a href=\"http:\/\/www.borncity.com\/blog\/2017\/10\/11\/sicherheits-updates-fr-windows-78-1-oktober-2017\/#comment-48906\" target=\"_blank\" rel=\"noopener\">this comment<\/a>, mentions trouble accessing Excel files from Access.<\/p>\n<blockquote><p>Since the last window supdate 10.10.2017, it is no longer possible to link excel files to Access 2000, or to open linked excel files.<\/p><\/blockquote>\n<p>Other comments within my blog confirmed an Excel data base access error. Microsoft was aware of this issue, as the following text indicates :<\/p>\n<blockquote><p>Issue where applications based on the Microsoft JET Database Engine (Microsoft Access 2007 and older or non-Microsoft applications) fail when creating or opening Microsoft Excel .xls files. The error message is, \"Unexpected error from external database driver (1). (Microsoft JET Database Engine)\".<\/p><\/blockquote>\n<h2>Microsoft patches only some Windows builds<\/h2>\n<p>On November 2, 2017 Microsoft released a couple of extra ordinary updates, some are addressing the Microsoft JET Database Engine bug. Here are the updates:<\/p>\n<ul>\n<li><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ssl-vg03.met.vgwort.de\/na\/be212ff935b44b4e90391e005891ee5c\" alt=\"\" width=\"1\" height=\"1\" \/>Update KB4052234 for Windows 7 SP1 und Windows Server 2008<\/li>\n<li>Update KB4052233 for Windows 8.1 und Windows Server 2012 R2<\/li>\n<li>Update <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/4052231\" target=\"_blank\" rel=\"noopener\">KB4052231<\/a> for Windows 10 Anniversary Update (Version 1607)<\/li>\n<li>Update <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/4052232\" target=\"_blank\" rel=\"noopener\">KB4052232<\/a> for Windows 10 Version 1511<\/li>\n<\/ul>\n<p>For Windows 10 Fall Creators Update (V1709) Microsoft have had released cumulative update <a href=\"https:\/\/support.microsoft.com\/en-us\/help\/4043961\" target=\"_blank\" rel=\"noopener\">KB4043961<\/a> on am 10\/17\/2017. This addresses also the Microsoft JET Database Engine issue. For all other Windows 10 builds (Windows 10 RTM and Windows 10 Creators Update, version 1703) no update is available.<\/p>\n<h2>Issues and a workaround<\/h2>\n<p>Installing the updates mentioned above is a bitter sweet pill. They are fixing the Microsoft JET Database Engine issue, but are causing other issues. For instance:<\/p>\n<blockquote><p>After installing KB4041681, package users may see an error dialog that indicates that an application exception has occurred when closing some applications. This can affect applications that use mshtml.dll to load web content. The failure only occurs when a process is already shutting down, and doesn't impact application functionality.<\/p><\/blockquote>\n<p>Details may be found within the kb articles linked above. Microsoft is working on a resolution and will provide an update in an upcoming release. I guess, not everybody will install the updates mentioned above, due to the side effects. But there is a workaround for the en Microsoft JET Database Engine error.<\/p>\n<p>Instead of using the Microsoft.Jet.OLEDB.4.0 provider, use the Microsoft Access Database Engine (ACE) Provider. Download and install the <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=13255&amp;751be11f-ede8-5a0c-058c-2ee190a24fa6=True\" target=\"_blank\" rel=\"noopener\">Microsoft Access Database Engine 2010 Redistributable<\/a>. Then change the DB connection string in Microsoft Excel (or in other apps) to the ACE provider. The string<\/p>\n<p><em>Provider=Microsoft.Jet.OLEDB.4.0<\/em><\/p>\n<p>need to be changed to:<\/p>\n<p><em>Provider=Microsoft.ACE.OLEDB.12.0<\/em><\/p>\n<p>The Microsoft Excel is able to read Access data bases.<\/p>\n<p><strong>Addendum:<\/strong> Both updates for Windows 7\/8.1 has been pulled, see\u00a0Windows 7\/8.1: KB4052234 &amp; KB4052233 has been pulled<\/p>\n<p><strong>Similar articles<\/strong><br \/>\n<a href=\"https:\/\/borncity.com\/win\/2017\/08\/09\/patchday-august-2017-updates-for-windows-78-1\/\">Patchday August 2017: Updates for Windows 7\/8.1<\/a><br \/>\n<a href=\"https:\/\/web.archive.org\/web\/20210621072002\/https:\/\/borncity.com\/win\/2017\/11\/03\/update-rollups-for-windows-78-1-november-2-2017\/\">Update Rollups for Windows 7\/8.1 (November 2, 2017)<\/a><br \/>\n<a href=\"https:\/\/web.archive.org\/web\/20230329085923\/https:\/\/borncity.com\/win\/2017\/11\/03\/windows-10-updates-november-2-2017\/\">Windows 10 Updates November 2, 2017<\/a><br \/>\nWindows Flash Player 27.0.0.183 Update KB4051613<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[German]Microsoft released a fix for the Microsoft JET Database Engine bug on November 2, 2017. This update fixes the problem with the Access or Excel database connection, but not in all versions of Windows. Here are some details about the &hellip; <a href=\"https:\/\/borncity.com\/win\/2017\/11\/04\/microsoft-tries-to-fix-the-jet-database-engine-bug\/\">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,22,2],"tags":[188,47,1129,195,194],"class_list":["post-4180","post","type-post","status-publish","format-standard","hentry","category-issue","category-update","category-windows","tag-bug","tag-issue","tag-jet-database-engine","tag-update","tag-windows"],"_links":{"self":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/4180","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=4180"}],"version-history":[{"count":1,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/4180\/revisions"}],"predecessor-version":[{"id":35700,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/4180\/revisions\/35700"}],"wp:attachment":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/media?parent=4180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/categories?post=4180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/tags?post=4180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}