Error - The Microsoft Jet database engine cannot find the input table or query 'Mode'.


 Product(s):Promis.e, Bentley Substation
 Version(s):through 08.11.13.140
 Environment:N/A
 Area:Installation_Configuration
 Subarea:N/A

Error or Warning Message

The following error message is displayed, typically at startup.

Internal Error
UI Error Message: The Microsoft Jet database engine cannot find the input table or query 'Mode'. Make sure it exists and that its name is spelled correctly.
TargetSite: System.Data.DataTable GetTable(Int32, System.String)
DeclaringType: MDBProxy.LocalTools
Attributes: public
MemberType: Method...


Explanation

The Multi_Lanuage_UI.mdb database should contain a table named Mode. The software is unable to find or read from this table for some reason.

How to Avoid

  1. Open the [[Setup]] dialog and select the System Paths tab to determine the path to the Multi_Lanuage_UI.mdb file. If necessary, temporarily set  Select system path management method to "Manage Individual Paths" to see the Language databases field that contains this path.
  2. Make a backup copy of the Multi_Lanuage_UI.mdb file in a convenient location.
  3. Replace the Multi_Language_UI.mdb file with a copy of the file from a workstation without the issue, from a backup known to be good, or from the [[Default Data folder contents]] . 

If this resolves the error message but some customizations (custom symbol attributes, custom language phrases, custom dialog text) are missing, compare the suspect Multi_Lanuage_UI.mdb to the one that resolved the issue using Microsoft Access. It may be possible to copy the missing data into the good Multi_Lanuage_UI.mdb file.

If the above process did not resolve the issue, check permissions on the Multi_Lanuage_UI.mdb file and containing folder.

 Original Author:Bhargav Chintalapati