<div>
Check this thread,<br />
<br />
<a href="http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/6b9761bb-f195-446b-94c2-a77a87201487/" rel="ugc nofollow">http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/6b9761bb-f195-446b-94c2-a77a87201487/</a>
</div>


Check this thread,

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/6b9761bb-f195-446b-94c2-a77a87201487/ [http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/6b9761bb-f195-446b-94c2-a77a87201487/]

<div>
You get this on &quot;all&quot; of the linked tables?<br />
Do these tables all have a designated Primary Keys?
</div>


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

<div>
Yes - all tables. Some tables have primary keys.
</div>


Yes - all tables. Some tables have primary keys.

<div>
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.
</div>


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.

<div>
They need to have the 64-bit odbc admin thing flash &quot;64-bit&quot; in big red letters
</div>


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

<div>
<div class="content wysiwyg-content">
I have an MS Acccess front end to SQL Server 2008R2.<br />
All DSN configurations are set correctly. But I still get an error message when trying to open the linked tables.<br />
Error message is &quot;ODBC--connection to 'DB010' failed.&quot;<br />
Any thoughts?
</div>
</div>


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?

MS Access - SQL Server ODBC Error

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.