Go Back   Access World Forums > Apps and Windows > SQL Server

 
View Poll Results: Did the Nov 2014 SQL Server Patch affect your Access Linked Tables
Yes - I use the ODBC that came with the Operating System 1 50.00%
Yes - I Use the SQL Server Native Client Pre version 10.0 0 0%
Yes - I use the SQL Server Native Client 10.0 or 11.0 1 50.00%
No - I use Native Client 10.0 or 11.0 1 50.00%
No - I use Native Client Pre 10.0 0 0%
No - I use the ODBC that came with the Operating System 0 0%
Yes - I use something different 0 0%
No - I use something different 0 0%
Multiple Choice Poll. Voters: 2. You may not vote on this poll

Reply
 
Thread Tools Rate Thread Display Modes
Old 11-24-2014, 06:54 AM   #1
Rx_
Nothing In Moderation
 
Rx_'s Avatar
 
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,800
Thanks: 636
Thanked 337 Times in 307 Posts
Rx_ has a spectacular aura about Rx_ has a spectacular aura about Rx_ has a spectacular aura about
Exclamation SQL Server update breaks Access Linked Table Application

Don't Panic
(Large Friendly Letters)
A re-post of a news item.
As a promoter of the SQL Server Native Client, I wanted to post this and ask anyone if they have encountered this issue?

It appears that the older SQL Server Native Client will break after this SQL Server update is installed. There was no indication of the standard ODBC having this issue.

For myself, I use the latest SQL Server Native Client 11.0. We have not had the problem appear.

If anyone else is doing this, it wouldn't hurt to weigh in.
I have added a Poll for those who use SQL Server Linked Tables

Code:
Posted: 20 Nov 2014 07:41 PM PST
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.
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/downl....aspx?id=36434
Downloading Native Client 10 is a little more complex, first navigate to this page:
http://www.microsoft.com/en-us/downl....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

__________________
Were you lucky enough to get an answer? Please mark your question as [SOLVED] The original poster can go to Thread Tools to mark it as Solved.

Quotation Thomas Jefferson: "Peace is that brief glorious moment in history when everybody stands around reloading."

There are 2 Kinds of Countries on this Planet
1. Those that use the Metric System
2. Those that had a man walk on the moon

Denver, Colorado - The "Mile High City" - non-metric!
Rx_ is offline   Reply With Quote
Old 11-25-2014, 09:33 PM   #2
accedeholdings
Newly Registered User
 
Join Date: Sep 2014
Posts: 15
Thanks: 3
Thanked 3 Times in 3 Posts
accedeholdings is on a distinguished road
Re: SQL Server update breaks Access Linked Table Application

Can you give us an update if whether or not you are successful with the updates?
accedeholdings is offline   Reply With Quote
Old 11-26-2014, 06:01 AM   #3
Rx_
Nothing In Moderation
 
Rx_'s Avatar
 
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,800
Thanks: 636
Thanked 337 Times in 307 Posts
Rx_ has a spectacular aura about Rx_ has a spectacular aura about Rx_ has a spectacular aura about
Re: SQL Server update breaks Access Linked Table Application

My server already had Native Cleint 11.0. The indications are that the update only affected those Pre- Native Client 11.0.
Yes, we would all appreciate people weighing in as to how they fare with the SQL Server Update.
Those considering applying the SQL Server updates may want to schedule them as not to impact the users.

__________________
Were you lucky enough to get an answer? Please mark your question as [SOLVED] The original poster can go to Thread Tools to mark it as Solved.

Quotation Thomas Jefferson: "Peace is that brief glorious moment in history when everybody stands around reloading."

There are 2 Kinds of Countries on this Planet
1. Those that use the Metric System
2. Those that had a man walk on the moon

Denver, Colorado - The "Mile High City" - non-metric!
Rx_ is offline   Reply With Quote
Old 11-26-2014, 07:41 AM   #4
kevlray
Newly Registered User
 
Join Date: Apr 2010
Location: Central California
Posts: 642
Thanks: 9
Thanked 51 Times in 49 Posts
kevlray will become famous soon enough
Re: SQL Server update breaks Access Linked Table Application

Our server/dba staff applies the patches to our various SQL databases. As of yet I do not think that any of our DB's are up to 2012 (still at 2008 R2 for most). It is interesting to note, I needed to download an ODBC driver (for an Excel query project) for a client, but found that the Native Client 10.0 was no longer available, so I had to download the Native Client 11.0, which so far is working just fine.
kevlray is offline   Reply With Quote
The Following User Says Thank You to kevlray For This Useful Post:
Rx_ (12-01-2014)
Old 12-01-2014, 02:45 PM   #5
Rx_
Nothing In Moderation
 
Rx_'s Avatar
 
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,800
Thanks: 636
Thanked 337 Times in 307 Posts
Rx_ has a spectacular aura about Rx_ has a spectacular aura about Rx_ has a spectacular aura about
Re: SQL Server update breaks Access Linked Table Application

Guess I had better update my tips with that information.
Just as well, the 10.0 download was hidden better than a Income Tax preperation instruction.

__________________
Were you lucky enough to get an answer? Please mark your question as [SOLVED] The original poster can go to Thread Tools to mark it as Solved.

Quotation Thomas Jefferson: "Peace is that brief glorious moment in history when everybody stands around reloading."

There are 2 Kinds of Countries on this Planet
1. Those that use the Metric System
2. Those that had a man walk on the moon

Denver, Colorado - The "Mile High City" - non-metric!
Rx_ is offline   Reply With Quote
Reply

Tags
linked tables , odbc , sql server 2008 , sql server native client

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy data from local Access table to linked SQL Server table WaiveIt General 1 01-14-2014 09:38 AM
Refresh and update data from a table in Access linked to SQL Server mo9rissat Tables 0 07-24-2012 12:14 AM
How to convert a Access application to SQL server application? marks2007 Modules & VBA 3 11-12-2007 09:05 AM
Append Records from an Access Table to SQL Server Linked Table Steven Deetz Queries 1 07-23-2006 05:05 PM
Delete Server Table from Access Application Alika Modules & VBA 4 04-28-2004 09:51 AM




All times are GMT -8. The time now is 02:49 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World