Search code examples
sql-server-2008ms-accessodbc-sql-server-driver

Options for best MS Access ADO to SQL Server Connection Performance

What provider and driver offer the best performance when connection to SQL Server using ADO?

I'm connecting MS Access 2007 to SQL Server 2008.

Provider Options:

  1. OLE DB provider for ODBC (MSDASQL.1) (default provider)
  2. OLE DB provider for SQL Server (SQLOLEDB)
  3. There may be other options that I'm not aware of

Driver Options:

  1. SQL Server (version 2000.85.1132.00 - SQLSRV32.DLL 4/14/2008)
  2. SQL Server Native Client 10.0 (version 2007.100.2531.00 SQLNCLI10.DLL 3/30/2009)
  3. There may be other options that I'm not aware of.
Solution

  • You should test it in your specific environment to be sure. Whatever the performance differences are, they should be negligible.