avoorheis
asked on
change all the connections for linked tables in ms access 2003
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:
dbo_tblTest (DSN=MyDSN;)
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=My Userid;Tru sted_Conne ction=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.
thanks
alan
dbo_tblTest (DSN=MyDSN;)
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=My
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.
thanks
alan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.