MS Access - SQL Server ODBC Error

Posted on 2012-08-30
Medium Priority
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 74

Expert Comment

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

Author Comment

ID: 38350784
Yes - all tables. Some tables have primary keys.
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

LVL 21

Accepted Solution

mastoo earned 2000 total points
ID: 38351118
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

ID: 38351473
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

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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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 how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

809 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