Help and Support

ACC2000: Slow Performance When You Open Objects in Design View in Access Running on Microsoft Windows NT 4.0

View products that this article applies to.
Article ID:264239
Last Review:June 28, 2004
Revision:3.0
This article was previously published under Q264239
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

For a Microsoft Access 2002 version of this article, see 293199 (http://support.microsoft.com/kb/293199/EN-US/).
On This Page

SYMPTOMS

After you upgrade to Microsoft Windows NT 4.0 Service Pack 6/6a on a client computer without upgrading the server to the same service pack, opening Access objects such as forms, reports, macros, or modules in Design View across a network is unusually slow. You may also notice a delay when you enter the first character in a module in the Visual Basic Editor. This problem does not occur with data access pages.

Back to the top

RESOLUTION

You can use either one of the following solutions to resolve this problem:
Make sure that the client computers are running the same service pack as the server. The server may be running either Windows NT Server 4.0 or NT Workstation 4.0.

-or-

Obtain the latest Microsoft Jet 4.0 service pack from the Microsoft Download Center

For additional information about how to obtain the latest Microsoft Jet 4.0 service pack, click the following article number to view the article in the Microsoft Knowledge Base:
239114 (http://support.microsoft.com/kb/239114/) How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine

Back to the top

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 2000 running on Microsoft Windows NT 4.0.

Back to the top

MORE INFORMATION

Steps to Reproduce the Behavior


1.On a client computer that has Service Pack 6 installed, start Access 2000, and then create a new database named TestSP6.mdb.
2.In the Database window, click Forms under Objects, click New, click Design View, and then click OK.
3.Add a text box to the form.
4.On the File menu, click Save, and save the form as Form1.
5.Quit Access 2000.
6.Copy the TestSP6.mdb file to a shared network drive on the server. Make sure the server computer is configured with Windows NT Workstation or Server 4.0, Service Pack 5 or earlier.
7.On the client computer, start Access 2000, and then open the TestSP6.mdb file from the network share.
8.In the Database window, click Forms under Objects, click Form1, and then click Design. Note the delay that occurs. The delay is considerably longer then when you open the form in a database that is stored locally on the client computer.

Back to the top

REFERENCES

For additional information about performance issues with Windows NT 4.0, click the article number below to view the article in the Microsoft Knowledge Base:
236316 (http://support.microsoft.com/kb/236316/EN-US/) Performance Improvement for Redirector/Server Connections Involving Small File Operations

Back to the top

APPLIES TO
•Microsoft Access 2000 Standard Edition

Back to the top

Keywords: 
kbbug kbpending KB264239

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.