ODBC insert on a linked table failed. Cannot find the object xxxxx because it does not exist or you do not have permissions
Q: I just updated to a new version and when trying to add a new training record, I am now getting an error "ODBC insert on a linked table 'FilterTraining' failed. Cannot find the object 'tblRegsiter' because it does not exist or you do not have permissions"
A: From SQL Management Studio, please make sure that your Windows login user is listed under the main Security folder (not under the database security; you can can check there also if this does not resolve the issue) with "datareader" and "datawriter" permissions in User Mapping. If the issue persists, please try also checking off db_owner under user mapping.
Tags: Installation, ODBC, Client.