A
Arvin Meyer [MVP]
For some of my clients MDBs I've noticed that they take up 40 Mb of
RAM on startup. With only loading two forms. So I suspect Access is
loading all the VBA code into RAM on startup.
Some time ago, it may have been more than 10 years ago, I remember being
told by someone at Microsoft that when you called a VBA sub or function, the
entire module was loaded into memory. So rather than single large modules
for every like typed code, it was preferable to load often used functions
into the same module, and keep the modules separated by usage frequency and
code affinity. IOW, It doesn't necessarily make sense to put all the string
functions in 1 module and date functions in another unless you are doing it
for storage or cataloging purposes.