Added field causes extreme delay in spooling

  • Thread starter Thread starter levieux
  • Start date Start date
L

levieux

Running Access 2000 I have a main report (with a
subreport) that takes about 20 seconds to format the page
and begin printing. The recordsource for both report and
subreport are queries that join three ODBC-linked SQL
tables. I added one date/time field to the subreport
query with a corresponding new text box to the
subreport. The query and subreport still run fine, but
when I try to run the main report with the subreport the
report never finishes formatting or spooling. I do not
get an error message. If I take the new field off the
subreport (even though I leave it in the source query),
the whole thing runs fine again.
 
No. They're all set to "NO". (I just copied a text box
that's already in the report and set the data source to
the new field.)
 
I have no idea why this would cause an issue if you didn't adjust the size
of the section or set something to can grow. I would also try to compact
after adding the control to see if that makes a difference.
 
Compacting didn't work. I am accessing this database via
Terminal Services and I asked a collegue in another
state, where the server resides, to try it. It ran fine
for him. He's going to try it via Terminal Services and
see if he has problems with it.

Thanks for your input.
 
Back
Top