Message 1 of 3
fixing VBA memory leak problem
Not applicable
06-08-2006
05:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
I have written an app in VBA that could be finished except for the seemingly unsolvable memory leaks that are inherent in VBA.
I am hoping to migrate everything into VB.NET and want to take a look down this road so I do not smash into another wall.
I have done all the good cleanup practices in my code but I still watch task manager inflate until the inevitable fatal crash that will always happen when working with thousands of entities, selection sets, etc.
I am wondering if in .NET .....objects, collections, and arrays will be released from memory when set to nothing as is the promise of the NET framework. So far in this group there is hardly any mention of the memory leak problems that have been asked in the VBA group that but have not been really adressed with real solutions.
I wonder if making a standalone VB.NET app can over come this problem or should it be a hybrid windows.form exe calling a dll.
I am hoping to migrate everything into VB.NET and want to take a look down this road so I do not smash into another wall.
I have done all the good cleanup practices in my code but I still watch task manager inflate until the inevitable fatal crash that will always happen when working with thousands of entities, selection sets, etc.
I am wondering if in .NET .....objects, collections, and arrays will be released from memory when set to nothing as is the promise of the NET framework. So far in this group there is hardly any mention of the memory leak problems that have been asked in the VBA group that but have not been really adressed with real solutions.
I wonder if making a standalone VB.NET app can over come this problem or should it be a hybrid windows.form exe calling a dll.