You are currently reviewing an older revision of this page.
At startup, the following or similar error message is displayed and catalog items such as symbols cannot be inserted.
Internal ErrorUI Error Message: ExecuteSQL error. create PROCEDURE BlkInfo AS selectblkName,anum,blkDesc,desc_id,type,date_modify,category,0 AS FileInfo_id,blkSymXML from sym0The 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.LocalToolsAttributes: publicMemberType: Method...
This message can indicate a problem with the Device.mdb file. In one case it occurred after incorrectly trying to rename a catalog.
Refer to the following articles for the path to Device.mdb and a link to a fresh copy of this file.Device.mdb - Promis.eDevice.mdb - Substation
Rename or delete the suspect Device.mdb.
Replace the Device.mdb with the known good copy of Device.mdb.
Keywords: sym1, sym2, dev0, dev1, dev2, mac0, mac1, mac2, tit0, tit1, tit2