ODBC--Connection to 'DataSourceName' failed.

Posted on 2005-04-28
Last Modified: 2012-08-13
Good afternoon expert,

We have an Access database which is linked to
a MS SQL Server databse. The application works
fine for every one except a new user. When she brings up the application, when she submits he user name and password she gets
ODBC--Connection to 'DataSourceName' failed.
This error message is followed by another error message:
Microsoft Access cannot open the table in Datasheet view.
I have checked her ODBC connection in Control Panel
Administrative Tools Datasources (ODBC) and made sure that there is a System DNS exactly like the other users. There is a permission granted to all the users
in her Domain to the SQL server database but I went ahead and added her specifically. Still the same message.
Any ideas how to troubleshoot this?


Allen in Dallas

Question by:9apit
    LVL 65

    Expert Comment

    by:Jim Horn
    (Knee-jerk, Help Desk-like comment) Did you destroy and re-create the linked table, and try again?
    LVL 11

    Accepted Solution

    1. If you create a new DSN in the ODBC Manager (on her machine) using her NT credentials, does it connect?
    2. Could be problem with MDAC version on her machine.
    3. Experience a problem once with ODBC registry entry.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now