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.
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=322389/
)
How to obtain the latest Windows XP service pack
Hotfix
information
A supported hotfix is 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 software update that contains this hotfix.
If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.
Note If additional issues occur or if 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. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.
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
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
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=821557/
)
MS03-027: An unchecked buffer in the Windows shell could permit your system to be compromised
- You must also add and enable the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Lanmanworkstation\Parameters\DisableFlushOnCleanup registry subkey. For information about how to add and configure the registry subkey, see the "Add and enable the registry subkey" 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
Installation information
Verify the Shell32.dll file version
- Click Start, and then click Search.
- Click All files and folders.
- In the All or part of the file name box, type Shell32.dll.
- Click Search.
- In the right pane, right-click Shell32.dll, and then click Properties.
- 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 HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Lanmanworkstation\Parameters\DisableFlushOnCleanup registry subkey:
- Click Start, click Run, type regedit in the Open box, and then click OK.
- Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Lanmanworkstation\Parameters
- On the Edit menu, point to New, and then click DWORD Value.
- Type DisableFlushOnCleanup, and then press ENTER.
- On the Edit menu, click Modify.
- In the Value data box, type 1, and then click OK.
- Quit Registry Editor.
- Restart your computer.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft Windows XP Service Pack 2.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
824684Â
(http://kbalertz.com/Feedback.aspx?kbNumber=824684/
)
Description of the standard terminology that is used to describe Microsoft software updates