Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Change the password for linked tables in access

Avatar of Ross_G
Ross_G asked on
Microsoft Access
6 Comments1 Solution7152 ViewsLast Modified:
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.