topic Re: Automation stays in memory! in Software Archive

Automation stays in memory!

rahzan — Fri, 22 Feb 2002 05:20:58 GMT

I have a COM server used by vba (msaccess) it appears that teh dang thing STAYS in memory after the vba clint is done ( and "removes the reference" successfully) and even if I copy a new DLL AND register it again while access is open.

The only way to get the new DLL to become effective is to completely shut access down and back on, again.

Is there a way for the server to unload itself (or from within vba, or some other place to free unused libraries??) without shutting access down.

Any hints will be VERY much helpful.

TimH

Re: Automation stays in memory!

rahzan — Fri, 22 Feb 2002 07:00:19 GMT

Have the client call the WIN API routine CoFreeUnusedLibraries

Re: Automation stays in memory!

Intel_C_Intel — Fri, 22 Feb 2002 23:13:22 GMT

Perhaps this registry tweak?

http://www.winguides.com/registry/display.php/667/

Re: Automation stays in memory!

rahzan — Sat, 23 Feb 2002 04:00:19 GMT

Thanks,
The registry solution works but it really should be reserved for "low memory" systems since it totally disables chaching which under other cirsumstances may cause big slow downs.

Tim