Hello, We have an Access FE application connecting to a BE SQL 2005. Recently we changed SQL servers, new name, ip and dsn. I created a new ODBC, then went into Access and changed the Link tables to reflect the new ODBC. I am able to update the tables to the new SQL server but when I try to run a Form that is used to update our Territories I get the "run-time error '3151' odbc connection failed" error. It sends me to VB code and here is where I get lost. I tried to review the code to see if the old db is hardcoded somewhere but couldn't find anything.
Any suggestions to correct this would be greatly appreciated! Tim