Knowledge Base

Poor Performance with Access MDB Stored on Windows NT Server

Article ID: 197876

Article Last Modified on 10/31/2006

APPLIES TO

This article was previously published under Q197876

SYMPTOMS

You may notice that it takes several seconds longer to open an Access MDB file stored on a Windows NT Server computer than if the same MDB is stored on a Windows95 or Windows 98 computer.

CAUSE

This problem occurs because the Windows NT Server computer is not optimized for file sharing.

RESOLUTION

To resolve this problem, do the following:

  1. Open Control Panel on the Microsoft Windows NT Server.
  2. Double-click the Network icon.
  3. Click the Services tab.
  4. Double-click the Server Service.
  5. Click to select the Maximize Throughput For File Sharing radio button.
  6. Restart the server.

STATUS

This behavior is by design.

MORE INFORMATION

If the MDB files are stored on a Windows95 or Windows 98 computer, the performance returns to normal.

Keywords: kbprb KB197876


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.