Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 293199 - Last Review: August 10, 2004 - Revision: 6.1
Slow performance when you open objects in Design View in Access running on 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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=264239/EN-US/
)
.
On This Page
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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.
MORE INFORMATION
Steps to Reproduce the Behavior
- 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.
- In the Database window, click Forms under Objects, click New, click Design View, and then click OK.
- Add a text box to the form.
- On the File menu, click Save, and then save the form as Form1.
- Quit Access.
- 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.
- On the client computer, start Access, and then open the TestSP6.mdb file from the network share.
- 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.
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://kbalertz.com/Feedback.aspx?kbNumber=236316/EN-US/
)
Performance Improvement for Redirector/Server Connections Involving Small File Operations
APPLIES TO
- Microsoft Access 2002 Standard Edition, when used with:
| kbperformance kbprb kbpending KB293199 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please