locked
"Unexpected error from external database driver (1). " when create a CSV spreadsheet using VB program RRS feed

  • Question

  • Hi,

    I have old VB program works fine until some update (released October 10<sup>th</sup>, 2017)

    User get "Unexpected error from external database driver (1). "  when create a CSV spreadsheet using VB program.

    Anyone expert give me any solution? I reinstall 32 bit AccessDatabaseEngine.exe. It doesn't help!

    What else I can try to get fixed?

    Many Thanks!

    Monday, October 23, 2017 7:25 PM

Answers

  • Should I remove the KB4041678 at the first?

    Hi Daphne1212,

    Based on your situation, you may try the solution in Visakh16's link first.

    Reference Workaround

    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.

    If the solution doesn't work, you could remove the patch(KB4041678/KB4041681/KB4041686) or try other ways in Naomi's link.

    Hope these are helpful to you.

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, October 24, 2017 5:45 AM

All replies

  • Thats the known issue with the KB I guess. It seems to break the JET driver

    https://support.microsoft.com/en-us/help/4041681/windows-7-update-kb4041681

    Solution is to remove the KB applied or to go for ACE provider


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page


    • Edited by Visakh16MVP Monday, October 23, 2017 7:33 PM
    • Proposed as answer by Naomi N Monday, October 23, 2017 8:02 PM
    Monday, October 23, 2017 7:32 PM
  • Thank you!

    How to remove KB4041681?

    Monday, October 23, 2017 7:55 PM
  • Thank you!

    How to remove KB4041681?

    Go to  Control Panel > Programs and Features>Installed Updates. just find your KB being listed and click uninstall

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page


    • Edited by Visakh16MVP Monday, October 23, 2017 8:03 PM
    Monday, October 23, 2017 7:59 PM
  • Should I remove the KB4041678 at the first?
    Monday, October 23, 2017 8:10 PM
  • That thread offers other solutions. Check if they can solve your problem.

    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog


    My TechNet articles

    Monday, October 23, 2017 8:57 PM
  • Should I remove the KB4041678 at the first?

    Hi Daphne1212,

    Based on your situation, you may try the solution in Visakh16's link first.

    Reference Workaround

    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.

    If the solution doesn't work, you could remove the patch(KB4041678/KB4041681/KB4041686) or try other ways in Naomi's link.

    Hope these are helpful to you.

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, October 24, 2017 5:45 AM
  • This is caused by kb4041681 update.

    On kb4041681 article page: https://support.microsoft.com/en-us/help/4041681/windows-7-update-kb4041681

    We can read in Known issues in this update that:

    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)".

    And there is workaround and solution: 

    This issue has been resolved in KB4052234. This solution will also be available in the November 14, 2017 release.

    Note: HotFix KB4052234 was released just yesterday (2 Nov 2017)

    Friday, November 3, 2017 3:20 PM
  • Start => Add or remove programs=> View Installed Updates

    Anish

    Monday, December 18, 2017 5:30 AM