SQL Server update breaks Access application

UPDATE 12/3/14: Please visit Darren’s blog for the latest on this issue, than come back here to see some solutions to this problem. You can visit Darren’s blog here.

My inbox has been flooded by reports around the world of Access suddenly being slow or unusable after the latest set of patches issued by Microsoft.

MS Access Consulting

Turns out one of the patches for SQL Server will in effect render Access applications using the native SQL Server drivers in Windows useless as reported here by Darren Myher.

None of our client applications were affected since we have long migrated all of our clients to SQL Native Client 10 and more recently SQL Native Client 11.

For an example on how to use the native client please refer to this post.

The only drawback to using the client is that it requires installation of either the 32 bit or 64 bit of the driver on every PC using the application. (Select 32 or 64 based on the version of your Windows OS and NOT the version of your Office Suite).

Here are the download links to Client 11:


Downloading Native Client 10 is a little more complex, first navigate to this page:


Click on the plus sign next to Install Instructions

Navigate down the long page to the section titled

Microsoft® SQL Server® 2008 R2 Native Client


There you will find three links, one for the processor technology you have installed on your PC. Don’t worry if you pick the wrong version, it will simply error out on installation and not install anything, at which point you can come back to the download page and try again,

Like this SQL Server with Access tip? Than you will LOVE our monthly SQL Server with Access Virtual Group meetings! To signup please visit http://accessusergroups.org/sql-server-with-access/ we meet every second Tuesday of the month.


About the Author:

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.


  1. Bill Mosca December 2, 2014 at 11:18 pm - Reply

    Darren’s blog has been updated to state that MS has released another patch that fixes the bad one.

  2. Mark November 21, 2014 at 4:46 pm - Reply

    Thank you for the heads up

Leave A Comment


Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.