Microsoft KB Archive/231798

= Access Database with Multiple Users Slow on Terminal Server =

Article ID: 231798

Article Last Modified on 2/27/2007

-

APPLIES TO


 * Microsoft Windows NT Server 4.0, Terminal Server Edition Service Pack 4
 * Microsoft Windows NT 4.0 Service Pack 4
 * Microsoft Windows NT Server 4.0 Standard Edition
 * Microsoft Windows NT 4.0 Service Pack 1
 * Microsoft Windows NT 4.0 Service Pack 2
 * Microsoft Windows NT 4.0 Service Pack 3

-



This article was previously published under Q231798



SYMPTOMS
When multiple users on a computer running Windows NT Server 4.0, Terminal Server Edition attempt to open the same Microsoft Access database on another computer running Windows NT Server, performance may be severely degraded. However, single Terminal Server users do not experience any performance degradation.

If several Terminal Server users communicate with different servers containing Access databases, performance is not impaired, but when they open the same database, query timing may be an order of magnitude slower.



CAUSE
This behavior occurs because database record locking is affecting performance. By default, Terminal Server establishes a single session with the Windows NT Server-based computer that contains the database. Multiple users querying the database through that one session can cause conflicts. When you use Network Monitor to track network traffic, the trace shows that the computer is no longer using opportunistic locking.



RESOLUTION
To resolve this issue, apply the fix described in the following Microsoft Knowledge Base article:

190162 Terminal Server and the 2048 Open File Limitation

This article describes how to set up different sessions between the servers, and describes changes to Terminal Server that are made with Service Pack 4. After you apply the fix and restart the computer, the performance issue should be resolved.

In addition, if there are multiple users on the computer doing large amounts of record locking, refer to the following article in the Microsoft Knowledge Base:

191370 Slow Network Performance with Terminal Server

Keywords: kbinterop kbnetwork kbprb KB231798

-

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

© Microsoft Corporation. All rights reserved.