Error at startup - cannot find input table or query sym0

 Product(s):Promis.e, Bentley Substation

Error or Warning Message

At startup, the following or similar error message is displayed and catalog items such as symbols cannot be inserted.

Internal Error
UI Error Message: ExecuteSQL error. create PROCEDURE BlkInfo AS select
blkName,anum,blkDesc,desc_id,type,date_modify,category,0 AS FileInfo_id,blkSymXML from sym0
The Microsoft Jet database engine cannot find the input table or query 'sym0'. Make sure it exists and that its name is spelled correctly.
TargetSite: Void ExecuteSQL(Int32, System.String)
DeclaringType: MDBProxy.LocalTools
Attributes: public
MemberType: Method...


This message can indicate a problem with the Device.mdb file. In one case it occurred after incorrectly trying to [[Rename a catalog|rename a catalog]].

How to Avoid

  1. Refer to the following articles for the path to Device.mdb and a link to a fresh copy of this file.
    [[Device.mdb - Promis.e]]
    [[Device.mdb - Substation]]

  2. Rename or delete the suspect Device.mdb.

  3. Replace the Device.mdb with the known good copy of Device.mdb.

 Original Author:Matt_P

Keywords: sym1, sym2, dev0, dev1, dev2, mac0, mac1, mac2, tit0, tit1, tit2