title: Significant performance differences between Access on Windows Server 2008 R2 and Windows Server 2019
body: <p>In our company we have to support a large legacy system built on Microsoft Access 2010 as frontend and SQL Server 2008 R2 as backend. The backend SQL server runs on Windows Server 2008 R2. Currently our users works on Terminal Server sessions on a Windows Server 2008 R2. A couple of days ago we started to test Windows Server 2019 and Notebooks with the latest version of Windows 10. We recognized a big performance difference while executing the same Access databases on the different environments.</p>
  
  <p>For instance the creation of a report takes 27 seconds (new environment) instead of 7 seconds (old environment). The database.accdb is identical, the backend is identical (still Windows 2008 R2 Server with SQL Server 2008 R2 and SP2), only the execution environment (Windows) changed.</p>
  
  <p>Does anyone of you have an idea how to explain this?</p>
  
  <p>In Access 2010 the SQL server tables are linked using System-DSN data sources. On the old environment ODBC is used (Driver: SQL Server, Version: 6.01.7601.17514).</p>
  
  <p>On the new environment I tested the following drivers:</p>
  
  <ul>
  <li>ODBC Driver 11 for SQL Server (2014.120.5543.11)</li>
  <li>ODBC Driver 17 for SQL Server (2017.173.01.01)</li>
  <li>SQL Server (10.00.17763.01)</li>
  <li>SQL Server Native Client 10.0 (2009.100.4000.00)</li>
  <li>SQL Server Native Client 11.0 (2011.110.5058.00)</li>
  </ul>
  
  <p>I created a new System-DSN using the different drivers and updated the linked tables in Access. But in any case the performance is still bad. I also tested the latest version of Access which comes with Office 2019, but again it is slow.</p>