Invalid Object Name error when committing an Edit Set.

Version 1

    Details

    Invalid Object Name or Table or View does not exist error on commit of an Edit Set.

     When committing an Edit Set modifying any table, user receives the following error and the Edit Set terminates:

    "Invalid Object Name HEATTbl"

    Or:

    "Table or View Does not Exist" error referencing an insert to the HEATTbl table.

     


    Resolution

    Cause
    The Edit Set process drops tables and recreates them. No matter which table is altered through the edit set, all of the following tables are dropped in this order and recreated. If the ODBC user does not have Create Table rights, then they will receive one of these two errors.

    HEATTbl

    HEATFld

    HEATXTbl

    HEATXFld

    HEATFmt

    HEATCtrl

    HEATDTyp

    HEATForm

    HEATCtyp

    HEATCust

    HEATEscT

    HEATEscL

    HEATSym

    HEATGen


    Resolution
    Grant “Drop Table” and “Create Table” rights to the database user whose credentials are being used in the ODBC connection.