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

hi Ozair,

What kind of Number? Long Integer? If it's Double, they aren't precise for joins

kind regards,
crystal

On 9/5/2023 2:26 AM, ozair wrote:

Crystal,

I am sure I did not intentionally removed previous messages. 
Throughout the application, the JOINS are always on Number data type.

Best,
Ozair

PS : Forgive me if it again removes the previous messages to the thread.
On Tue, Sep 5, 2023 at 12:13 AM, crystal (strive4peace) wrote:

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

 

 


On Tue, Sep 5, 2023 at 12:13 AM, crystal (strive4peace) wrote:

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

 

 On Tue, Sep 5, 2023 at 12:13 AM, crystal (strive4peace) wrote:

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

 

 On Tue, Sep 5, 2023 at 12:13 AM, crystal (strive4peace) wrote:

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

 

 On Tue, Sep 5, 2023 at 12:13 AM, crystal (strive4peace) wrote:

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

 

 On Tue, Sep 5, 2023 at 12:13 AM, crystal (strive4peace) wrote:

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

 

 On Tue, Sep 5, 2023 at 12:13 AM, crystal (strive4peace) wrote:

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

 

 On Tue, Sep 5, 2023 at 12:13 AM, crystal (strive4peace) wrote:

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

 

 On Tue, Sep 5, 2023 at 12:13 AM, crystal (strive4peace) wrote:

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

 

 On Tue, Sep 5, 2023 at 12:13 AM, crystal (strive4peace) wrote:

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