MS Access - SQL Server ODBC Error

Posted on 2012-08-30
Last Modified: 2012-08-30
I have an MS Acccess front end to SQL Server 2008R2.
All DSN configurations are set correctly. But I still get an error message when trying to open the linked tables.
Error message is "ODBC--connection to 'DB010' failed."
Any thoughts?
Question by:kris_sk2012
    LVL 9

    Expert Comment

    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    You get this on "all" of the linked tables?
    Do these tables all have a designated Primary Keys?

    Author Comment

    Yes - all tables. Some tables have primary keys.
    LVL 21

    Accepted Solution

    What version of Access and is it 32 or 64 bit?
    This is new or did it stop working?
    And the biggest question, when you configure your odbc source there is a "Test Connection" button - have you verified this works?

    Author Closing Comment

    Thanks - you made me think why I have two ODBC configurations on Windows 7 PC. I was configuring 64 bit, but when I configured 32 bit, this worked like a charm.
    LVL 21

    Expert Comment

    They need to have the 64-bit odbc admin thing flash "64-bit" in big red letters

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    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…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    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

    17 Experts available now in Live!

    Get 1:1 Help Now