Microsoft KB Archive/918144

= Description of the Jet 4.0 Database Engine post-837001 hotfix package: May 11, 2006 =

Article ID: 918144

Article Last Modified on 10/11/2007

-

APPLIES TO

 Microsoft Access 2000 Standard Edition Microsoft Access 2002 Standard Edition Microsoft Office Access 2003 Microsoft Office Access 2003, when used with:  Microsoft Windows Server 2003, Datacenter Edition (32-bit x86)

 Microsoft Windows Server 2003, Enterprise Edition

 Microsoft Windows Server 2003, Standard Edition (32-bit x86)</li></ul>

 Microsoft Windows Server 2003, Web Edition</li></ul>

 Microsoft Windows Server 2003, Datacenter Edition for Itanium-Based Systems</li></ul>

 Microsoft Windows Server 2003, Enterprise Edition for Itanium-based Systems</li></ul>

 Microsoft Windows Server 2003, Datacenter x64 Edition</li></ul>

 Microsoft Windows Server 2003, Enterprise x64 Edition</li></ul>

 Microsoft Windows Server 2003, Standard x64 Edition</li></ul>

 Microsoft Windows XP Embedded</li></ul>

<ul> <li>Microsoft Windows XP Service Pack 2</li></ul>

<ul> <li>the operating system: Microsoft Windows XP 64-Bit Edition SP1</li></ul>

<ul> <li>Microsoft Windows XP Professional for Itanium-based systems</li></ul> </li></ul>

-

<div class="notice_section">

<div class="symptoms_section">

This article describes the Microsoft Jet 4.0 Database Engine issues that are fixed in the Jet 4.0 Database Engine post-837001 hotfix package. This hotfix is dated May 11, 2006.

The following issues are fixed in this hotfix package but were not previously documented in a Microsoft Knowledge Base article: <ul> <li>Consider the following scenario. You create a query against a linked SQL Server table where the left join is an inner join on itself. In this scenario, when you try to run the query, you receive an error message that resembles the following:

ODBC--Call Failed.

[Microsoft][ODBC SQL Server Driver][SQL Server] The column prefix 'name' does not match with a table name or alias name used in the query. (#107)

</li> <li>When you use the Jet 4.0 database on a multi-processor computer or a hyper-threaded computer, you receive an error message that resembles the following:

Access has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of something, the information you were working on might be lost. Please tell Microsoft about this problem.

We have created an error report that you can send to help us improve Access. We will treat this report as confidential and anonymous. To see what data this error report contains, click here.

When you view the data that the error report contains, you see the following list that contains information about some of the most common error signatures. This information may vary depending on the version of Access or the application that you use as the front end for the Jet 4.0 database engine. </li> <li>When you use a Jet 4.0 database, you may receive an error message that resembles the following:

Access has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of something, the information you were working on might be lost. Please tell Microsoft about this problem.

We have created an error report that you can send to help us improve Access. We will treat this report as confidential and anonymous. To see what data this error report contains, click here.

When you view the data that the error report contains, you see the following list that contains information about some of the most common error signatures. This information may vary depending on the version of Access or the application that you use as the front end for the Jet 4.0 database engine. </li> <li>When you use a Jet 4.0 database, you may receive an error message that resembles the following:

Access has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of something, the information you were working on might be lost. Please tell Microsoft about this problem.

We have created an error report that you can send to help us improve Access. We will treat this report as confidential and anonymous. To see what data this error report contains, click here.

When you view the data that the error report contains, you see the following list that contains information about some of the most common error signatures. This information may vary depending on the version of Access or the application that you use as the front end for the Jet 4.0 database engine. </li> <li>When you use a Jet 4.0 database, you may receive an error message that resembles the following:

Access has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of something, the information you were working on might be lost. Please tell Microsoft about this problem.

We have created an error report that you can send to help us improve Access. We will treat this report as confidential and anonymous. To see what data this error report contains, click here.

When you view the data that the error report contains, you see the following list that contains information about some of the most common error signatures. This information may vary depending on the version of Access or the application that you use as the front end for the Jet 4.0 database engine. </li> <li>The Citrix Independent Management Architecture (IMA) service experiences an access violation in the Msjet40.dll file on a Microsoft Windows Server 2003 x64-based computer in a 32-bit or WOW64 process.</li></ul>

<div class="resolution_section">

Service pack information
To resolve this problem, obtain the latest service pack for Windows Server 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

889100 How to obtain the latest service pack for Windows Server 2003

Prerequisites
To install this hotfix, you must have Windows Server 2003 Service Pack 1 (SP1) or security update 837001 installed on your computer. For more information about how to obtain the latest service pack for Windows Server 2003, click the following article number to view the article in the Microsoft Knowledge Base:

889100 How to obtain the latest service pack for Windows Server 2003

Security update 837001 is described in security bulletin MS04-014. For more information about security bulletin MS04-014, click the following article number to view the article in the Microsoft Knowledge Base:

837001 MS04-014: Vulnerability in the Microsoft Jet Database Engine could permit code execution

Restart requirement
If you use the Jet 4.0 database engine, you must restart your computer after you apply this hotfix.

Hotfix replacement information
This hotfix replaces security update 837001 and other Jet 4.0 service packs.

File information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

Windows Server 2003, x86-based versions
<div class="resolution_section">

Microsoft Windows XP hotfix information
A supported hotfix is now available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next service pack that contains this hotfix.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:

http://go.microsoft.com/?linkid=6294451

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Prerequisites
To install this hotfix, you must have Windows XP Service Pack 2 (SP2) or security update 837001 installed on your computer. 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 How to obtain the latest Windows XP service pack

Security update 837001 is described in security bulletin MS04-014. For more information about security bulletin MS04-014, click the following article number to view the article in the Microsoft Knowledge Base:

837001 MS04-014: Vulnerability in the Microsoft Jet Database Engine could permit code execution

Restart requirement
If you use the Jet 4.0 database engine, you must restart your computer after you apply this hotfix.

Hotfix replacement information
This hotfix replaces security update 837001 and other Jet 4.0 service packs.

File information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section. This problem was first corrected in Windows Server 2003 Service Pack 2.

<div class="moreinformation_section">

MORE INFORMATION
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

<div class="references_section">