maximum no of open forms & subforms

[Florin]

Hi everyone.
I'm using Access 2007 front-end connected to SQL Server Express 2008.

I've created dinamic dashboards using multiple subforms on one form.
The subforms themselves have datasheet subforms when that is required.
So if I have a dashboard showing 10 panels (subforms), each of them with a
subform for the datasheet I easily end up with 21 forms open at once on just
one window.

I hit a snag. if I open mmore than 4 dashboards of this sort, the database
starts acting up: most of the time it simply doesn't load forms.
Are you aware of any limitation in the number of open forms & subforms in an
access database?

Here's a post in my blog with a test database attached, to test this
behaviour.

http://accesser.blogspot.com/2009/03/maximum-number-of-open-forms-subforms.html

Thanks for any ideas!
Florin

 

[KC-Mass]

Hi,

Believe you can see the limits here:
http://www.access-freak.com/tutorials.html#Tutorial01

Regards

Kevin

 

[Florin]

Thanks Kevin, but there's no mention of *loaded* forms there.
In fact couldn't find anywhere something like this mentioned.
Florin

 

[Florin]

Update.
I've tested some more and it looks like it's a matter of memory.
Virtual Bytes to be exact.
Once the Virtual Bytes counter in perfmon reaches a certain value (about
2,120,000,000) access throws the runtime error 2004: "there isn't enough
memory to perform this operation".
Ideas?
Thanks!

 

[Florin]

Another note:

I've tested in various ways and it looks like Access reserves at least 10 MB
for every form or subform it opens.
Depending on the form it can be more. But an empty form takes around 10 MB.
Sure, once it reaches a high number of forms and subforms, and the virtual
memory used goes over 2 GB on my test system, Access runs out of memory.
I tried increasing the Virtual Memory in the System Properties (win xp pro)
with no positive results.

The question now is: why does access need so much memory for an empty form?
Is there a way I can minimize that?

Thanks!
Florin