I have a suite of applications written for SQL Server 2000 in Access 2000 and Access 2007 and running under Access 2007 (12.0.6423,1000 SP2 MSO 12.0.6425.1000) via ODBC with the SQL Server ODBC driver (2000.85.1132.00) under Windows XP Professional
(2002 SP3). I have maintained all the data modules in Access 2000 format so that they can be accessed by SQL Server 2008 if required and am gradully upgrading the data modules to SQL Server. The server they are connected to is Microsoft SQL Server
Standard Edition (10.0.2531.0 running on a 32-bit Wndows Server 2008 Standard (SP2).
As a security improvement I intend to move a number of the applications to the server itself. My choice of driver for ODBC is between SQL Server (6.00.6002.18005) and SQL Server Native Client 10.0 (2007.100.2531.00). I have yet to discover any
differences in application behavior or performance between the two interfaces
My assumption is that I will have have fewer problems if I configure the ODBC links using the SQL Server driver. However, I was wondering if there is a reason to gradually move them over to the SQL Server Native Client 10.0 driver.
View Complete Post