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: Please make sure that your Windows login user is listed under logins of 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 checking off db_owner under user mapping also.