[Last Call] Learn how to a build a cloud-first strategyRegister Now


change all the connections for linked tables in ms access 2003

Posted on 2011-04-27
Medium Priority
Last Modified: 2012-05-11
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=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.

Question by:avoorheis
1 Comment

Accepted Solution

andymacf earned 2000 total points
ID: 35479463
It looks like you need to reconfigure your connection to your tables so it is looking at the same connection for all tables.  Here is a helpful link:



Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question