<div>
Thanks, &nbsp;I'll review and give it a try.
</div>


<div>
<div class="content wysiwyg-content">
We replaced a server 2003 SQL 2005 32 bit with a server 2008 R2 SQL 2005 64 bit. &nbsp;Programs (using ODBC) updated on the new server run fine from the workstations (mostly Win 7 64 bit). &nbsp;The same ODBC definition is unable to see or connect to the new server from the workstations. &nbsp;<b>An MS Access ADP is unable to run from the workstations; &nbsp;it runs fine on the new server. &nbsp;I have checked the SQL client drivers, comm protocols, and permissions.<br />
Please help. </b><br />
The ODBC problem is Question 1 - separate.
</div>
</div>


We replaced a server 2003 SQL 2005 32 bit with a server 2008 R2 SQL 2005 64 bit.  Programs (using ODBC) updated on the new server run fine from the workstations (mostly Win 7 64 bit).  The same ODBC definition is unable to see or connect to the new server from the workstations.  An MS Access ADP is unable to run from the workstations;  it runs fine on the new server.  I have checked the SQL client drivers, comm protocols, and permissions.
Please help. 
The ODBC problem is Question 1 - separate.

Connecting to a new SQL Server Question 2

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.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.