Is there anything else that should be done when a form is closed?
I ask this because I have observed with the Task Manager, Access 2000 taking 20,000K memory with my main form open. From there I link to another form, keeping main form open. With that second form open, Access is sucking up 29,000K memory. Close new form, Access is not using 25,000K memory, not the original 20K.
Open the code editor, Access sucks another 11,000L. or so. Close code editor, Access continues to suck that 11,000K memory. Every form that I open uses more memory and Access doesn't free it bacdk up, or it only frees up part of it.
This goes with another thread I have going, but is different. What happens to the variable arrays and other variables when a form closes. From my experiment, it looks like they remain in memory. Is there anything I can do besides "DoCmd.Close" when a form is due to close. Is there an memory flushing or garbage collection that can be done?
If you have enough forms, it looks like Access just keeps gobbling memory and not giving it back and then slows down. Creating an MDE version of the database seems to alieviate memory, but even then it keeps gobbling and not giving back, but at least has a lot further to go.
I ask this because I have observed with the Task Manager, Access 2000 taking 20,000K memory with my main form open. From there I link to another form, keeping main form open. With that second form open, Access is sucking up 29,000K memory. Close new form, Access is not using 25,000K memory, not the original 20K.
Open the code editor, Access sucks another 11,000L. or so. Close code editor, Access continues to suck that 11,000K memory. Every form that I open uses more memory and Access doesn't free it bacdk up, or it only frees up part of it.
This goes with another thread I have going, but is different. What happens to the variable arrays and other variables when a form closes. From my experiment, it looks like they remain in memory. Is there anything I can do besides "DoCmd.Close" when a form is due to close. Is there an memory flushing or garbage collection that can be done?
If you have enough forms, it looks like Access just keeps gobbling memory and not giving it back and then slows down. Creating an MDE version of the database seems to alieviate memory, but even then it keeps gobbling and not giving back, but at least has a lot further to go.