asked on

Change the password for linked tables in access

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.

cyberkiwi

Access 2003 or 2007?

Ross_G

ASKER

Was written in 2003, but have 2007 to access if necessary.

cyberkiwi

Right-click on any linked table, choose "Linked Table Manager"
Select all the tables (Select All), then tick "Always prompt for location"

When prompted, select the new ODBC dsn, and provide a password if not using Windows Authentication.
So as not to be confused, it may be easier just creating a new ODBC DSN beforehand.

Ross_G

ASKER

Tried this. Created a new DSN. LInked fine, but asks for the password each time you start up. If you flag the 'trusted connection', you get the ODBC errors back. This access need to run in the background and be invisible to the user..

ASKER CERTIFIED SOLUTION

cyberkiwi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ross_G

ASKER

Thanks - all working correctly now. Appreciate your quick response!!