Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Error message when Installing OpenUtilities Substation related to Microsoft Access or Microsoft Office 365
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • -OpenUtilities Substation
      • -CONNECT Edition - OpenUtilities Substation
        • +3D Layout Features - OpenUtilities-Substation
        • +Administration Features - OpenUtilities Substation
        • +Automation Feature
        • +Component management - OpenUtilities Substation CONNECT
        • +Components Features - Substation CONNECT
        • +Construction Drawing - Openutilities Substation CONNECT
        • +Database Platform Support - OpenUtilities Substation
        • +Drawing Managment - OpenUtilities Substation
        • -Installation_Configuration - Bentley Substation CONNECT Edition
          • +Compatibility Chart OpenUtilities Substation CONNECT
          • Configuration Files - Bentley Substation v10.00-10.02
          • Configuration Files - Bentley Substation v10.03+
          • Configuration Variables - Bentley Substation v10.00-10.02
          • Configuration Variables - Bentley Substation v10.03+
          • Creating New WorkSpace & WorkSet - OpenUtilities Substation
          • Deployment Guide - Bentley Substation CONNECT Edition v10.03+
          • Deployment Guide - Substation CONNECT Edition v10.00-10.02
          • +Deployment Image - OpenUtilities Substation
          • Error due to Microsoft Access Database Engine
          • How to Clean Install OpenUtilities Substation
          • How to Deploy Custom Parts Database Manager layout - OpenUtilities Substation
          • +How to download the Bentley Substation software
          • How to Silent Install OpenUtilities Substation
          • -Installation Errors - Installation_Configuration - OpenUtilities Substation CONNECT Edition
            • Error message when Installing OpenUtilities Substation related to Microsoft Access or Microsoft Office 365
            • Error: A problem was detected with the Microsoft Access Database Engine installation...... OpenUtilities Substation
            • Error: The given key was not present in the dictionary - Substation CONNECT
            • Fail to load plugin in OpenUtilities Substation CONNECT
          • Migrating Bentley Substation from V8i to CONNECT Edition - Bentley Substation v10.00-10.02
          • Migrating Bentley Substation from V8i to CONNECT Edition v10.03+
          • Program Data / Configuration Folder
          • Program Folder - OpenUtilities Substation CONNECT
          • System Requirements OpenUtilities Substation CONNECT Edition
          • Working with Template WorkSets - Bentley Substation v10.00-10.02
          • Working with Template WorkSets - Bentley Substation v10.03+
        • +Maintenance Feature - Open Utilities Substation CONNECT
        • +Migration - OpenUtilities Substation CONNECT
        • +OS & Hardware Support - OpenUtilities Substation CONNECT
        • +Panel Layout- Substation CONNECT
        • +Power Platform Support - Substation CONNECT
        • +Print and Plot feature
        • +Print and Publish feature
        • +Project Management - OpenUtilities Substation CE
        • +ProjectWise Integration - OpenUtilities Substation CONNECT
        • +Replace Device ID - Find_Replace - OpenUtilities Substation
        • +Reports_Output Features - OpenUtilities Substation CONNECT
        • +Resolved issues in OpenUtilities Substation Releases
        • +Wire Numbering - Substation CONNECT
        • +Wiring Feature - OpenUtilities Substation
      • +3D Layout Features - Bentley Substation
      • About Bentley Substation
      • +Administration Features - Bentley Substation
      • +Automation Features - Bentley Substation
      • +Component Management - Bentley Substation
      • +Construction Drawings - Bentley Substation
      • +Database Platform Support - Bentley Substation
      • +Grounding Grid - Bentley Substation
      • How to log Service Request
      • +Installation_Configuration - Bentley Substation
      • +Interoperability - Bentley Substation
      • +PowerPlatform Support - Bentley Substation
      • +Project Management - Bentley Substation
      • +ProjectWise Integration - Bentley Substation
      • Working from home with OpenUtilities Substation
    • Promis.e Paths
    • +Promis.e Wiki
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    Error message when Installing OpenUtilities Substation related to Microsoft Access or Microsoft Office 365

      Product(s): OpenUtilities Substation CONNECT Edition
      Version(s):  10.14.XX.XX through 
      Environment:  NA
      Area:  Installation_Configuration 
      Subarea:  NA

    Background:

    Historically Access Database Engines (ADE) have been used OUS & Promis.e CONNECT for connecting with different MDB files like PartsDatabase.mdb, Multi-Language_UI.mdb, Catalog.mdb, device.mdb and ECADProject.mdb. Hence ADE was essential for version until OUS U13& Promis.e CONNECT U11. The latest being ADE 2016. Below are the details of the above mentioned mdb for reference.


     

    Description

    MDB File

     

    PartsDatabase.mdb

    This MDB file is used to store Part Number information. User may have Part Number stored SQL Database or MDB file. The user can find location of the file from Configuration Variable "ELEC_ACTIVEPARTSDATABASE"

    Multi-Language_UI.mdb

    This MDB file is used to store Symbol Attributes, Information about different Modes and Language Phrases for Multi Language Text. The user can find location of the file from Configuration Variable "ELEC_LANGUAGE_DB_PATH"

    Catalog.mdb

    This MDB file is specific to a Catalog. This Catalog.mdb is used to store meta data information about Symbol, Title Block, Family and Macros that are saved in that Catalog. The user can find the file inside the Catalog folder according to the path in Configuration Variable "ELE_CATALOG_PATH"

    Device.mdb

    This MDB file is a Per User Application on user’s local machine used by Promis.e / OUS for internal system operation of the application. The file can be usually found in "C:\Users\Current Username \AppData\Local\Bentley\Substation\10.0.0\"

    ECADProject.mdb

    This MDB file is usually found inside the Project Backup file (*.prj). This MDB file is used to store all the backup of data from the Project Database associated with the Project so that it can be used when restoring the Project.

    Hence there are situation where the user machine would have ADE 2016 or older version and MS Office 365. Microsoft does not recommend installing Office 2016 and Office 365 applications on the same machine. Due to this whenever there is an update to MS Office 365 it would affect the ADE installation which in turn would affect the operation of OUS & Promis.e. When the user would start the application, they would get Error Message. For details click the below links.


    Microsoft Link

     

    Wiki Link for Error Message resolution

    Error due to Microsoft Access Database Engine
    Product(s): Substation CONNECT Version(s): Through 10.08.XX.XX Environment: N/A Area: Installation_Configuration Subarea: N/A Background In…
    Last edited 11 months ago in OpenUtilities > OpenUtilities Wiki



    Steps to Follow 

    To resolve the issue the latest version of OUS U14 & Promis.e CE U12 will be compatible with MS Office 365. Below are the recommendations depending on the user environment. 



    1. Client Machine with MS Office 365.

    If the user is using MS Office 365 then it is recommended that they use uninstall existing version of Access Database Engine on their machine when using Promis.e U12 or OUS U14 or higher in future.


    MS Office 365 version Compatibility with OUS refer to the below Compatibility Wiki Link

    Compatibility Chart - OpenUtilities Substation CONNECT (Update13 to 15)
    Product(s): OpenUtilities Substation Version(s): 10.13.00.XX to 10.15.00.XX Environment: N/A Area: Installation_Configuration Subarea: Compatibality Chart…
    Last edited 3 months ago in OpenUtilities > OpenUtilities Wiki


    If the user already has a version of MS Office 365 which is older than the above versions they will get the below Error Message when they install Promis.e CE or OUS indicating that they are running an older version and they to upgrade the version to more latest or compatible version.



    Note: Before Uninstalling Access Database Engine from your machine please confirm with IT Department if it would impact any other existing applications on the machine.




    2. Client Machine with no Office version installed.*

    When the user does not have any MS Office version installed the user can install the “Microsoft 365 Access Runtime” and uninstall any existing version of Access Database Engine. 


    Link to Download Microsoft 365 Access Runtime



    Note: Before Uninstalling Access Database Engine from your machine please confirm with IT Department if it would impact any other existing applications on the machine.

    If the user tries to install OUS or Promis.e CE with no Microsoft Office or Microsoft 365 Access Runtime they will get below error message.







    3. Client Machine with Microsoft Office 2016 or older version.

    When the user has Microsoft Office 2016 or older version installed it is recommended as a Best Practice to install “Microsoft 365 Access Runtime” and uninstall Access Database Engine until the Microsoft Office version is updated to MS Office 365.

    Link to Download Microsoft 365 Access Runtime






      Original Author: Satish Saptasagar
    • 365
    • error message
    • Microsoft Office 365
    • en
    • Installation_Configuration
    • OpenUtilities Substation
    • Microsoft Access
    • Share
    • History
    • More
    • Cancel
    • Satish Saptasagar Created by Bentley Colleague Satish Saptasagar
    • When: Thu, Jan 12 2023 1:37 PM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Mon, Jun 12 2023 7:50 AM
    • Revisions: 3
    • 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