none
140 Form instances, how can I get more ? RRS feed

  • 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 ...

    Tuesday, October 6, 2015 12:28 PM

Answers

  • 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.

    Tuesday, October 6, 2015 12:47 PM
  • 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

    Tuesday, October 6, 2015 1:30 PM

All replies

  • 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.

    Tuesday, October 6, 2015 12:47 PM
  • Hi. Does the number of open instances before you get the error changes with different sizes of computer memory?
    Tuesday, October 6, 2015 1:10 PM
  • 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

    Tuesday, October 6, 2015 1:30 PM