change all the connections for linked tables in ms access 2003
Posted on 2011-04-27
I have many linked tables and although the are linked with a DSN, they all seem to have different log in info from the DSN, which I've just updated. For example, if I look in the linked table manager, I see something like:
and MyDSN has the correct user/pw to access the table in our sql server DB.
If I hover over this linked table, I see something like:
ODBC; DSN=MyDSN; Description=sql2008;UID=MyUserid;Trusted_Connection=Yes; APP=2007 Microsoft Office system;;TABLE=dbo.MyTable
When I try to open the table, I get an error for a login failure that the user (and it lists the user that is logged into the computer).
Why doesn't it use the user/pw of the DSN?
How can I easily change all the tables to use a login that will work (preferably the DSN, since I don't have the computer user set up on the sql server yet.