Article ID: 142466
Article Last Modified on 8/9/2004
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
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