leebarnard
asked on
Extremely large increase in EXE size
i have a vb6/Access program that i have been doing maintenance work on for years. As i've added new functions i have seen the app grow in size in small increments. I made a few code changes and a new form the other day and now the app has changed from 5MG to over 15 MG. What could i have done that would make such a drastic increase in size?
Lee
somwhere I read that all modules in a office programms are claiming some memory, even after they are deleted.
perhaps a suggestion is to use a copy of the database, export from the other the modules and import them into the new database
or perhaps this might explain:
ACC2000: Delete Queries Cause Size of Replicated Database to Grow
http://support.microsoft.com/default.aspx?scid=kb;en-us;207629
ACC: Database Grows Rapidly When You Modify SQL Statements
http://support.microsoft.com/default.aspx?scid=kb;en-us;165823
perhaps a suggestion is to use a copy of the database, export from the other the modules and import them into the new database
or perhaps this might explain:
ACC2000: Delete Queries Cause Size of Replicated Database to Grow
http://support.microsoft.com/default.aspx?scid=kb;en-us;207629
ACC: Database Grows Rapidly When You Modify SQL Statements
http://support.microsoft.com/default.aspx?scid=kb;en-us;165823
Depends on the programming. If you use objects and do not set them to nothing when you're done, this will also cause Access apps to grow.
ASKER
my program is the one that has increased in size
servicewizard.exe - was 5mg
servicewizard.exe - now 15mg
i've been doing VB dev for quite a while and i have never seen this happen.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Big resources. VB save resources in exe. Try save resources in dll or resources file.
ASKER
jag you must be right. i did just add a new form and crystal report. although ive added others in the last few months and not noticed this large of an increase in file size. I'll monkey with it a bit to see if i can figure out what cause it. Ill accpet your answer as solution Thanks
virgil, yoiur suggestion of a separate dll is something id like to do. I have done that in MSVC++ but never in VB. I will post a new question on how to do that. hopefully you can share the steps to accomnplish that.
virgil, yoiur suggestion of a separate dll is something id like to do. I have done that in MSVC++ but never in VB. I will post a new question on how to do that. hopefully you can share the steps to accomnplish that.
Access is a poor user/releaser of memory, so a jump this large is not unheard of. You have to frequently compact-repair the Access database, which you can do using JRO code.