Stymied by report hang in Access 2000 (A2K)

[Larry Kahm]

I have one report that has a sub-report nested in another subreport (parent,
children, grandchildren). On my development machine, which is a single mdb,
there is no issue generating this report with sample data. On my test
machine, which uses a split mdb over a network, there is no issue generating
the report with client-provided data. However, at the client site which
uses a split mdb over a network, the report hangs with the Status bar
message: "Formatting page, press Ctrl+Break to stop..."

Each of the report queries displays the recordset without any problem. I am
tempted to take out the lowest level sub-report and see if (somehow) that
works, but that won't fix the problem.

I am open to any suggestions as to how to track down (or trace what is
happening) so I can isolate what, exactly, is causing the hang-up - and
correct it.

Many thanks!

Larry

 

[Larry Kahm]

Simon,

At this point the data is very small; the database is only recently
installed. Record counts as of yesterday: Parents = 22, Children = 67,
Grandchildren = 19 (I don't have the exact breakdown of who's got what).

There is an existing database at the site - over 1 GB - that is normally
"thrown" around the client's network without any (reported) problems - and
thousands of records get displayed in a reasonable amount of time. So I'm
thinking it is not that.

There's got to be some way of tracing what is going on in this report -
similar to the way one can walkthrough VBA - that would let me get a handle
on this.

Anyone?

Thanks!

Larry