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. 

To confirm permissions, please follow the steps below.

1. Open SQL Management Studio 

2. Click the (+) next to the Security folder on the left 

3. Click the (+) next to Logins

4. Right click on your login name or group to select "Properties"

5. Click on User Mapping on the left

6. Click on the TRAINTRACK database line so it is highlighted and make sure the check box is checked.

7. Select/confirm the permissions in the section below, then click "OK."

Tags: Installation, ODBC, Client.