140 Form instances, how can I get more ?

Question

Hello, 

if you open form-instances of a very simple Form (no Controls) you can "only" open 120-140 instances.

Then Appears the Error-Message "Not Enough Memory" Err-No: 2004.

Did anyone know how to get more Form-instances?

I test the behavior with Access 2010/Windows-7 64 Bit/ 20 GB Ram.

Please don't ask why ...

Answer 1

Hello, 

if you open form-instances of a very simple Form (no Controls) you can "only" open 120-140 instances.

Then Appears the Error-Message "Not Enough Memory" Err-No: 2004.

Did anyone know how to get more Form-instances?

I test the behavior with Access 2010/Windows-7 64 Bit/ 20 GB Ram.

Please don't ask why ...

Hi Mischa7788,

Without a "why" there is hardly a "that's why".

With so many opened instances, it is my feeling that you are walking on the edge of the possibilities, with consequences for performance and manageability. Instead of increasing the number of instances you could also try to use less instances. In all my applications - and there are a few very complex among them - I don't think I ever exceed 10 opened forms.

Imb.

Answer 2

Hi. Does the number of open instances before you get the error changes with different sizes of computer memory?

Answer 3

I doubt it. Nowadays even a crappy machine has several gigabytes of memory available. Access allocates internal buffers of small size that can be exceeded as the OP has proven. He should redesign his application, or use a different development tool.

---

-Tom. Microsoft Access MVP