Re: [MSAccessProfessionals] Error Out of Memory - How big is too BIG for MS Access?

hi Ozair,

you're welcome.

when you reply, please include previous messages in the thread so those following can keep up, thanks.

how to Quote Post .. Duane uploaded an image on how to quote post in a reply to show previous messages using the web interface here:

https://groups.io/g/MSAccessProfessionals/photo/249167/2977001

~~~
other email clients may have a different method such as an Advanced Setting to "Insert the original email text to a reply" (thanks, Giorgio)

I asked:

What are the data types for fields you're joining on?

and if text, what is Size?

thanks

kind regards,
crystal

---

Daniel has a helpful article. He calls this sort of thing "self-healing-object-variables"

https://www.devhut.net/self-healing-object-variables

---

On 9/5/2023 1:59 AM, ozair wrote:

Crystal,

Thanks for your input.
I believe I released them almost any time I used them. 

Example : 
Dim CurrDB as Dao.Database
SET CurrDB = CurrentDb()

' Some code
' Some code
' Some code
CurrDB.Close
SET CurrDB = Nothing


That article is nice, thanks.

Question : is the number of objects I have, beyond what Access can handle?

Best,
Ozair