THANKS! This concept worked. It took me awhile to figure out how to reset the ODBC, so I will try to clarify how to do this.

1. Deleted all LINKED tables to the backend SQL Server 2005 database.

2. Re-added all my LINKED tables, but during this process, when you get past selecting the ODBC DSN that you want to use and logging into SQL Server via that ODBC, you get a list of tables in the backend SQL Server 2005 database. This is where you select the tables you want to create links to. On the right-hand side of this screen is a little check-box that says "Save Password". Checking this and then confirming the message to save the password is what cleared the problem up.

Thanks Again!

🙂