There is a max, but realistically you should never reach it. Every variable you declare with a DIM takes up a tiny bit of resources, and every object you declare with SET should be destroyed. Access USUALLY does a pretty good job of clearing up that memory with the sub or function exits... but not always. So make sure you restart your database often and reboot your PC every couple of days. :)
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 26.