-
June 25th, 2001, 02:27 AM
#1
Memory
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
-
June 25th, 2001, 03:10 PM
#2
Re: Memory
Are all your routines set to Private.
Like this
Private Sub MyRoutine ()
End Sub
This will help. Also try Set MyVar = Nothing
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|