I have run int o a problem using VBA to batch convert access reports to pdf files. The code runs fine for a while, but at some point in the execution it will fail in the midst of creating a pdf and just keep adding pages to the file until I manually stop it. I have already checked the following:
1) It is not a problem with the report on which it fails - I can convert that report by itself or if I break the batches into smaller pieces.
2) There are no error logs reported.
3) After this occurs, the same problem exists for all pdfs I try to create, until I close and reopen PDFCreator.
I had the same issue. Take a look on the script and try to debbug it.
I have tried that, and continue to try to isolate the problem. It prints the first 133 files properly, than hangs. What wound up being the culprit for you?
Forgot to mention, I am using PDFCreator 1.7.0 on Windows 2003 R2 Enterprise SP2.
is it possible for you to post the script here or send it to us by email?
I sent the code to you - sorry about the delay in getting back to you, it didn’t let me know you had responded.
Hello? Did you receive the code?
Robin? Did you receive the code I sent?
yes I did, but no time to look at it in detail yet, sorry. I will let you know as soon as I find out anything.
we looked at it here together with a dev, but couldn´t find any obvious reason why this is happening. Could you modify your code to combine simple notepad files instead of access reports?
Then we could test it here also. One more idea would be to try version 1.6.2, because there are some general ghostscript issues in version 1.7.0. (If you downgrade, please uninstall->reboot->install older version)
I will try the version 1.6.2 and let you know.
hi there, quick searching on Google brings
me here.and Im working on pdf creating ,Is the script you mention written in
.Net? If yes ,Plz send me ,thx in adv.as a beginner in pdf creating
programming ,I just can’t figure out which script is best suiting me,
like pdf reader
sample codes[http://www.rasteredge.com/how-to/csharp-imaging/pdf-reading/] found by Google as well as your site.
the problem still exists in version 1.6.2, as well as 1.7.0 and 1.7.1
I believe this is an issue with memory resource allocation - if I just cancel the pdfcreator printer and try to continue using Access I get an Out of Memory error.