Go to Top

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.

ADVERTISING
ACCESS SAFETY AND TRAINING DATABASE

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:

http://www.microsoft.com/en-us/download/details.aspx?id=36434

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

http://www.microsoft.com/en-us/download/details.aspx?id=16978

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 Juan Soto

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.

2 Responses to "SQL Server update breaks Access application"

  • Bill Mosca
    December 2, 2014 - 11:18 pm Reply

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

  • Mark
    November 21, 2014 - 4:46 pm Reply

    Thank you for the heads up

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Contact Us
[gravityform id="16" title="false" description="false"]