Tuesday, March 31, 2009

maximum number of open forms & subforms in Access

Building my humungous application I ran into a big issue for me.
It seems like after opening a certain number of forms & subforms Access stops responding or opening new ones.
This number varies but I've created a test database that opens multiple instances of the same form.
No idea why this happens so please feel free to post here any thoughts you might have.

You'll probably ask why I need so many forms open so here's the reason:
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.
If I open more than 4 dashboards of this sort, the database starts acting up: most of the time it simply doesn't load forms. Other times it give errors.

Thanks for any ideas!

No comments: