Shamil Salakhetdinov
shamil at users.mns.ru
Sat Jun 9 11:17:57 CDT 2007
Hi Arthur, AFAIK MS Access loads whole modules. Once loaded they stay in memory until MS Access quits. MS Access loads standard modules on demand - as soon as a function/sub/property of a module is called this function's module is loaded. Class modules' are loaded on class's instance creation. For class modules just one copy of module's code is loaded but every instance has its own in memory copy of non static module level variables... -- Shamil -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Saturday, June 09, 2007 7:21 PM To: Access Developers discussion and problem solving Subject: [AccessD] Memory hit Suppose the following scenario: 1. I have a huge library of code, stored as classes or just functions and procedures. 2. I drag this library into my current app. 3. 70% of the code in said library is un-used in said current app. What is the cost in terms of physical disk size (can this be calculated?) and in terms of RAM? If I call one function in a library that contains 30 functions, does Access load the one or all 30? A. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com