Microsoft KB Archive/825433

= Poor performance when you append data to a shared file-based database from a Windows XP-based client =

Article ID: 825433

Article Last Modified on 11/15/2007

-

APPLIES TO


 * Microsoft Windows XP Professional for Itanium-based systems
 * Microsoft Office Access 2003
 * Microsoft Windows XP Professional for Itanium-based systems
 * Microsoft Access 2002 Standard Edition
 * Microsoft Windows XP Home Edition
 * Microsoft Windows XP Professional
 * Microsoft Access 2000 Standard Edition

-



Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry



SYMPTOMS
When you write to a shared file-based database from a Microsoft Windows XP-based client computer, you may experience poor performance. For example, you may experience poor performance when you run a query that appends data to a Microsoft Access database that is stored on a file server.



CAUSE
This problem occurs because the Windows XP redirector prematurely flushes the cache and writes the whole database back to the server one time for each append transaction to the database.



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

322389 How to obtain the latest Windows XP service pack

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 Windows XP 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
This hotfix has the following two prerequisites:   You must make sure that the Shell32.dll file has the following version or later.

Windows XP 32-bit editions:   Date         Time   Version        Size       File name    Service Pack level ---   11-Jun-2003  18:43  6.0.2800.1233  8,240,640  Shell32.dll  with Windows XP Service Pack 1 (SP1) 11-Jun-2003 18:53  6.0.2600.115   8,223,744  Shell32.dll  without Windows XP SP1 Windows XP 64-bit editions:   Date         Time   Version        Size        File name     Platform -  11-Jun-2003  18:44  6.0.2800.1233  14,369,792  Shell32.dll   IA-64 10-Jun-2003 15:39  6.0.2800.1233   8,240,640  Wshell32.dll  x86 For instructions about how to verify the file version, see the &quot;More Information&quot; section.

Note The version of the Shell32.dll file that is listed is the version that is installed when you apply the MS03-027 security update.

For additional information about the MS03-027 security update, click the following article number to view the article in the Microsoft Knowledge Base:

821557 MS03-027: An unchecked buffer in the Windows shell could permit your system to be compromised

 You must also add and enable the  registry subkey. For information about how to add and configure the registry subkey, see the &quot;Add and enable the registry subkey&quot; section.

Restart requirement
You must restart the computer after you apply this hotfix.

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 tool in Control Panel.

Windows XP 32-bit editions
  Date         Time   Version        Size     File name --  25-Mar-2004  22:34  5.1.2600.1367   92,160  Cscdll.dll 25-Mar-2004 22:24  5.1.2600.1367  420,736  Mrxsmb.sys 25-Mar-2004 22:24  5.1.2600.1367  166,016  Rdbss.sys

Windows XP 64-bit editions
  Date         Time   Version        Size       File name    Platform ---  25-Mar-2004  22:32  5.1.2600.1367    236,544  Cscdll.dll   IA-64 25-Mar-2004 20:50  5.1.2600.1367  1,276,416  Mrxsmb.sys 25-Mar-2004 20:50  5.1.2600.1367    495,616  Rdbss.sys 25-Mar-2004 22:34  5.1.2600.1367     92,160  Wcscdll.dll  x86

Verify the Shell32.dll file version

 * 1) Click Start, and then click Search.
 * 2) Click All files and folders.
 * 3) In the All or part of the file name box, type Shell32.dll.
 * 4) Click Search.
 * 5) In the right pane, right-click Shell32.dll, and then click Properties.
 * 6) Click the Version tab to view the file version.

Add and enable the registry subkey
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To add and to enable the  registry subkey:  Click Start, click Run, type regedit in the Open box, and then click OK.</li> Locate and then click the following registry subkey:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Lanmanworkstation\Parameters

</li> On the Edit menu, point to New, and then click DWORD Value.</li> Type DisableFlushOnCleanup, and then press ENTER.</li> On the Edit menu, click Modify.</li> In the Value data box, type 1, and then click OK.</li> Quit Registry Editor.</li> Restart your computer.</li></ol>

<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 Microsoft Windows XP Service Pack 2.

<div class="moreinformation_section">

MORE INFORMATION
For more information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

Keywords: kbbug kbfix kbqfe kbenv kbwinxpsp2fix kbwinxppresp2fix kbhotfixserver KB825433

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.