Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Error - 'Microsoft.ACE.OLEDB.12.0' provider not registered
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • +CONNECT Edition - Promis.e
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • -Automation Features - Promis.e
        • -Project API Builder - Automation Features - Promis.e
          • Error - 'Microsoft.ACE.OLEDB.12.0' provider not registered
          • Project API Builder
      • +Component Features - Promis.e
      • +Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • +Database Platform Support - Promis.e
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • +PowerPlatform Support - Promis.e
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • +Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • +Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

     
     Questions about this article, topic, or product? Click here. 

    Error - 'Microsoft.ACE.OLEDB.12.0' provider not registered

      Product(s): Promis.e, Bentley Substation
      Version(s): 08.11.13.57 - 08.11.13.140
      Environment: N\A
      Area: Automation Features
      Subarea: Project API Builder

    Error or Warning Message

    After specifying a .XLSX file on the Project API Builder dialog or in Project Manager > BOM Explorer > Import Spreadsheet Into BOM, an error message appears that includes the following text.

    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

    In one case the error message was:

    Information
    Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
       at System.Data.Common.UnsafeNativeMethods.lDBlnitializelnitialize.lnvoke(lntPtr pThis)
       at System. Data.OleDb.DataSourceWrapper.lnitializeAndCreateSession(OleDbConnectionString constr. SessionWrapper sessionWrapper)
       at System. Data.OleDb.OleDbConnectionlnternal..ctor(OleDbConnectionString constr. OleDbConnection connection) ...

    How to Avoid

    In the case of a Windows 8.1 64-bit operating system with 64-bit Microsoft Office 365/2016 installed, the error message was resolved by installing the 2007 accessdatabaseengine.exe available here.

    External Links

    HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"

      Original Author: Matt_P

    Keywords: OLEDB, TFS 78121

    • Automation Features
    • Project API Builder
    • promis.e
    • project manager
    • Bentley Substation
    • BOM Explorer
    • en
    • Project Management
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Wed, Aug 16 2017 4:00 PM
    • Matt_P Last revision by Communities MVP Matt_P
    • When: Tue, Apr 3 2018 5:45 PM
    • Revisions: 4
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies