I have a pile of access front ends that have been written to access an SQL back end via linked tables. The DB has been moved from one server to another, in another country!!, and the password for the linked tables is no longer valid. the ODBC DSN has been set up and works if you manually enter the new password in Link Manager to refresh the tables, but I need to change the password that the access db was given for the SQL when they were built. Any ideas on how we can do this?? I have trawled through Access and Google and have had no luck in finding this.
Thanks in advance.