Hello,
I have found this week that after linking to a SQL Server back end I am having trouble running some queries- I get a 'call failed' error (with no error number). I searched the causes for this error and the first thing that I came across said that this may be due to not having the latest Jet 4.0 service pack installed. Without the latest service pack, the linked db can't process some queries with outer joins, it says. Looking at the help article for getting the latest service pack (http://support.microsoft.com/kb/239114), I am confused. The article guides you to find the version of the service pack you currently have installed. Here is what it says:
I have windows XP SP2 but that is where the article is unclear- it says that SP2 means that you already have a later version than the one offered for download in this article. But then it says it is recommded to download the latest Sp for Windows, which is what I'm confused about. Does it mean that I have to get this widows SP3 thing and that will get me the latest Jet 4.0 service pack in the same shot? Or then I won't have to worry about the Jet service pack? I have to request permission for each separate download so I can't just download things left and right to see what works.
Would anyone familiar with the Call Failed error be able to shed some light on what this article means and what is the true solution to the problem that I should be seeking?
Thank you very much.
I have found this week that after linking to a SQL Server back end I am having trouble running some queries- I get a 'call failed' error (with no error number). I searched the causes for this error and the first thing that I came across said that this may be due to not having the latest Jet 4.0 service pack installed. Without the latest service pack, the linked db can't process some queries with outer joins, it says. Looking at the help article for getting the latest service pack (http://support.microsoft.com/kb/239114), I am confused. The article guides you to find the version of the service pack you currently have installed. Here is what it says:
<H3 id=tocHeadRef>For computers that are running Microsoft Windows XP
</H3>If you are running Windows XP SP2, you have a later version of Jet 4.0 than the version that is included with Jet 4.0 SP8. We recommend that you install the latest service pack for Windows XP. For more information about how to obtain the latest service pack for Windows XP, click the following article number to view the article in the Microsoft Knowledge Base:
322389 (http://support.microsoft.com/kb/322389/ )
How to obtain the latest Windows XP service pack
If you cannot install Windows XP SP2, you can use WindowsXP-KB829558-x86-ENU.exe to install Jet 4.0 Service Pack 8 on computers that are running Windows XP. Click the following link to download and to install the correct version of Jet 4.0 Service Pack 8 on computers that are based on the language version of Windows XP that is running on the computer.
I have windows XP SP2 but that is where the article is unclear- it says that SP2 means that you already have a later version than the one offered for download in this article. But then it says it is recommded to download the latest Sp for Windows, which is what I'm confused about. Does it mean that I have to get this widows SP3 thing and that will get me the latest Jet 4.0 service pack in the same shot? Or then I won't have to worry about the Jet service pack? I have to request permission for each separate download so I can't just download things left and right to see what works.
Would anyone familiar with the Call Failed error be able to shed some light on what this article means and what is the true solution to the problem that I should be seeking?
Thank you very much.