News, tips, advice, support for Windows, Office, PCs & more
Home icon Home icon

We're community supported and proud of it!

  • “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 Comment on the AskWoody Lounge

    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.