Microsoft KB Archive/293199

= Slow performance when you open objects in Design View in Access running on Microsoft Windows NT 4.0 =

Article ID: 293199

Article Last Modified on 8/10/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition, when used with:
 * Microsoft Windows NT 4.0

-



This article was previously published under Q293199



Moderate: Requires basic macro, coding, and interoperability skills.

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

For a Microsoft Access 2000 version of this article, see 264239.



SYMPTOMS
After you upgrade to the latest Microsoft Windows NT 4.0 service pack 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.



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 service pack from the Microsoft Download Center: For additional information about how to obtain the latest Microsoft Jet service pack, click the following article number to view the article in the Microsoft Knowledge Base:

239114 How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine





STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Behavior

 * 1) On a client computer that has the latest Microsoft Windows NT 4.0 Service Pack 6 installed, start Access, 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 then save the form as Form1.
 * 5) Quit Access.
 * 6) Copy the TestSP6.mdb file to a shared network drive on the server. Make sure that 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, 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.

