Topic: Exception Error "Object was open"

Hi all,

Has anyone ever had the Exception Error "Object was open" when running a report created by the Report Wizard?

I've been asked to run a report which would effectively output over 15 million lines which I suspect is the problem, as when I add a WHERE criteria to the report to restrict the number of lines in the output, it runs fine.

Best wishes,

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme