Hello,

Does anyone know of a way to explicity free the memory used by public variables in Access? The problem that I am having is that I am coming across and error due to the number of variables defined and I suspect that the memory is not being freed when the forms are closed. Is there any way around this?

Thanks in advance

Andrew