Reseting a database

[MartinF]

Hi,

Could anyone tell me how i can completely 'reset' a database and release all variable memory back to windows and unload any modules that may still be loaded into memory, but without quiting and restarting it?

The problem i have is that i have a process that seems to be holding up memory, so if you run it a second time without restarting the application you get 'Out of memory' errors.

I have checked through all the related code to be sure that it is efficient as i can make it but it still crashes the second time round.

Any help would be greatly appreciated in this area.

 

[Durkin]

I'm not sure if this will help but I once had a routine that would fill up memory if it was left to run by itself but if it was stepped through in debug mode would run fine. In the end we discovered that the garbage collection which should tidy up closed and finished variables wasn't getting time to run. The solution was to put a Doevents in the middle of the routine which gave the app time to tidy itself up before continuing. It's worth a try anyway. Durkin
alandurkin@bigpond.com

 

[MartinF]

Hi Durkin,

Thanks for the suggesstion, i tried it , but unfortunately the problem still persists.