• “Unexpected error from external database driver” error messages in Excel, Access, ODBC, cause by this month’s Windows patches

    Posted on October 17, 2017 at 09:34 CDT by • Comment in the Forums

    Yeah, I know it doesn’t make any sense, but that’s the general consensus. Looks like all of this month’s Windows patches changed the msexcl40.dll file to buggy version 4.0.9801.1.

    Computerworld Woody on Windows

    HOLY COW! Microsoft has modified all of the associated KB articles, not just acknowledging but explaining the error:

    Installing this update may cause applications based on the Microsoft JET Database Engine (Microsoft Access 2007 and older or non-Microsoft applications) to fail when creating or opening Microsoft Excel .xls files. The error message is, “Unexpected error from external database driver (1). (Microsoft JET Database Engine)”.

    Download and install the Microsoft Access Database Engine 2010 Redistributable, and then modify the DB connection strings in Microsoft Excel to use ACE as a provider. Example: Change Provider=Microsoft.Jet.OLEDB.4.0 to Provider=Microsoft.ACE.OLEDB.12.0.

    Microsoft is working on a resolution and will provide an update in an upcoming release.

    That’s a third fix, reported in several Answers forum posts.

    Thx to @mrbrian and his eagle eye.

    Office Patches/Security, Windows Patches/Security , , , , ,
DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.