Appendix B: Optimizing Access Applications
IN THIS APPENDIX
Taking advantage of VBA's Load on Demand functionality
Achieving better performance through compilation
Increasing the speed of your application
Using special techniques with large databases
When Microsoft introduced 32-bit Access, the new features and functions raised a number of new performance concerns. Microsoft continues to make a conscious effort to enhance the performance of the Access database engine, as well as compilation techniques and features such as the formerly undocumented Decompile command. The end result is that Microsoft has helped to ease your burden, but in no way has it completely eliminated that burden.
The published minimum RAM requirement for a computer to run Access on Windows XP (SP2 or later), Windows Server 2003 (or higher), Windows Vista, or Windows 7 is 256MB — with an emphasis on minimum. If you plan to do serious development with Access, you should have at least 512MB to 1GB of RAM (preferably, 2GB or more).
With today's computers and memory prices, this amount of memory is a valuable investment. In fact, simply adding more memory will increase speed much more than changing your processor speed because Access must use the hard drive as a virtual memory area if it doesn't have enough memory. Hard drives are slow, and big hard drives are even slower — regardless of the processor speed.
Understanding Module Load on Demand
One of the great features of Visual Basic for Applications (VBA), ...