Memory

[Andrew_Fryer]

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

[Andyb]

Are all your routines set to Private.

Like this

Private Sub MyRoutine ()

End Sub

This will help. Also try Set MyVar = Nothing