Microsoft KB Archive/142466

= Achieving Optimal Performance Paper Available in Download Center =

Article ID: 142466

Article Last Modified on 8/9/2004

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q142466



Advanced: Requires expert coding, interoperability, and multiuser skills.



SUMMARY
The Perfor95.exe file contains the Microsoft Access for Windows 95 "Achieving Optimal Performance" Technical Brief. This 10-page document discusses how to improve performance using enhanced features and tools such as Microsoft Jet Database Engine version 3.0 and the Visual Basic for Applications development environment.

The following file is available for download from the Microsoft Download Center:

Download Perfor95.exe now

The Perfor95.exe file contains the following files:   Perfor95.doc  Microsoft Access for Windows 95 Achieving Optimal Performance Technical Brief For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.



MORE INFORMATION
The "Achieving Optimal Performance" technical brief contains the following topics:

Purpose

Overview

Performance Gains in Microsoft Access for Windows 95

General Performance Gains

Performance Analyzer

Data Access Performance Gains

Conclusion

Introducing Visual Basic for Applications

Common Language Across Applications

Code Load-on-Demand

Developing Applications with Microsoft Access and Visual Basic for Applications

Compile All Modules

Save All Modules

Compile Loaded Modules

Losing the Compiled State

Decompiled Code

Dynamic Loading and Application Development

Two Application Scenarios

Scenario 1: Static Applications

Creating Efficient Modules

Reducing Number of Modules Opened

Opening Modules at Run Time (Application.Run)

Scenario 2: Dynamic Applications

Saving Space by Not Compiling

Separating Decompiled Code from Global Modules

No Circular References

Conclusion

Additional query words: performance optimization optimize optimizing improving Perfor95 exe doc inf

Keywords: kbhowto kbdownload kbgraphxlinkcritical kbfile KB142466

-

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

© Microsoft Corporation. All rights reserved.