Generating PDFs undesirably leaves files open

[google.groups.tr]

I have an Access 97 database that has a routine to generate a unique
report as a PDF file and email it to one person, and loops about 300
times. Each instance through the loop uses a registry entry to
pre-populate the desired filename for the PDF file it generates. The
PDFs are generated, attached and emailed in the loop as they're
intended.

As it progresses, the focus tends to show the Acrobat window and the
PDFs briefly appear as they are being generated, until it reaches the
last one that stays on top. The problem is that each PDF file remains
open in Acrobat, and it bogs down severely by the time you have dozens
of files open simultaneously there. When the loop finishes, one can
click "Window" in Acrobat's menu and see dozens of open files listed.

I guess the PDF Writer print driver insists on opening the PDFs for
review the instant it's done generating it. I don't want to review
them; I just want them to be generated.

How can I prevent this from occurring? I'm using Acrobat 5. (I know
this functionality was crippled in version 6, but that it not at issue
in this case.)

Regards,

Todd

[Steve Jorgensen]

You might have better luck with this http://pdf995.com/

On 2 Dec 2004 06:29:29 -0800, go**************@iid.state.ia.us wrote:

I have an Access 97 database that has a routine to generate a unique
report as a PDF file and email it to one person, and loops about 300
times. Each instance through the loop uses a registry entry to
pre-populate the desired filename for the PDF file it generates. The
PDFs are generated, attached and emailed in the loop as they're
intended.

As it progresses, the focus tends to show the Acrobat window and the
PDFs briefly appear as they are being generated, until it reaches the
last one that stays on top. The problem is that each PDF file remains
open in Acrobat, and it bogs down severely by the time you have dozens
of files open simultaneously there. When the loop finishes, one can
click "Window" in Acrobat's menu and see dozens of open files listed.

I guess the PDF Writer print driver insists on opening the PDFs for
review the instant it's done generating it. I don't want to review
them; I just want them to be generated.

How can I prevent this from occurring? I'm using Acrobat 5. (I know
this functionality was crippled in version 6, but that it not at issue
in this case.)

Regards,

Todd

[Nicole]

> I guess the PDF Writer print driver insists on opening the PDFs for

review the instant it's done generating it. I don't want to review
them; I just want them to be generated.

If it's feasible for your number of users, on each client computer go
to the Printer Properties -> Printing Preferences and uncheck the box
labelled "View PDF Results." This should prevent the PDF file from
automatically opening when a PDF is generated.