ODBC

I have a test database with an associated database, to which my database is linked via ODBC. I started with the links to the production version of the associated database, to which I have no rights. I used the Linked Table Manager to change the links to to the test version of the associated database. There are 3 tables, 1 of which I need, for which I cannot do this: when I click OK I get the message “aplication-defined or object-defined error”. The database administrator assures me that I have read, write and update rights to the table in the test version of the associated database. What might I be doing wrong?