Okay, the second post clears this up. Whenever the tables change on a back end, the linked table manager needs to be refreshed. I can look up how to automate this, but basically instead of unlinking and relinking, right click on the table, select Linked Table Manager, check the check box next to the tables, and then update the links.
It is not an ODBC issue, but this linked table manager issue.
Let me know if you need more help on this.
Look it up at: http://wrox.books24x7.com