P
P. Holck
A novice question about memory usage and subreports (using Access 2000
on WinXP Pro,, 768MB RAM with latest jet4.0 version 8, and I believe
very recent MDAC):
I believe I have a pretty inefficient report, consisting of 30-40
subreports and involving lots of tables, queries, charts, including
several linked tables from other Access 2000 (and a few Access 2002)
databases. The result is that I get the error "cannot open any more
tables" when I attempt a print preview of the main report, I'm
presuming because I have so many tables associated with the various
subreorts.
I am eager to modify my approach to reduce the memory usage that the
main report requires, however in order to minimize the changes I need
to make, I'd like to understand where the biggest benefit is going to
occur. Do I "reduce memory usage" much by pulling all tables into the
database rather than linking? Do I need to have my subreports source
be tables directly rather than queries? Any insight into this issue
would be greatly appreciated.
Finally I suppose I could try and split this "big report" into several
smaller reports. Problem is I'm doing a top-level group-by that in
effect produces a few page report for each person (group by is an
individual person). I then print this big report out (as a pdf file),
and distribute a specific idividualized hardcopy to each group member.
Perhaps there is someway I can use macros to assemble some of the
subreports that go to each individual? A long shot, and I realize
this is a bit vague.
Thanks in advance for any advice.
Peter
on WinXP Pro,, 768MB RAM with latest jet4.0 version 8, and I believe
very recent MDAC):
I believe I have a pretty inefficient report, consisting of 30-40
subreports and involving lots of tables, queries, charts, including
several linked tables from other Access 2000 (and a few Access 2002)
databases. The result is that I get the error "cannot open any more
tables" when I attempt a print preview of the main report, I'm
presuming because I have so many tables associated with the various
subreorts.
I am eager to modify my approach to reduce the memory usage that the
main report requires, however in order to minimize the changes I need
to make, I'd like to understand where the biggest benefit is going to
occur. Do I "reduce memory usage" much by pulling all tables into the
database rather than linking? Do I need to have my subreports source
be tables directly rather than queries? Any insight into this issue
would be greatly appreciated.
Finally I suppose I could try and split this "big report" into several
smaller reports. Problem is I'm doing a top-level group-by that in
effect produces a few page report for each person (group by is an
individual person). I then print this big report out (as a pdf file),
and distribute a specific idividualized hardcopy to each group member.
Perhaps there is someway I can use macros to assemble some of the
subreports that go to each individual? A long shot, and I realize
this is a bit vague.
Thanks in advance for any advice.
Peter