Bob C. wrote:
I have noticed that repeated attempts to run the automatic report generator
from either Access or Excel result in automation errors.
These errors can only be fixed by re-booting the computer.
Can anyone tell me what I'm doing wrong?


Try monitoring using Resource Meter or similar as you run the reports.
I have experienced resource leaks when using automation to Word to create reports.
I seem to recall getting an improvement by closing Word every N reports and re-opening it
(but that could have been in an old version and no longer necessary).


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup