Link to home
Start Free TrialLog in
Avatar of KGreg
KGreg

asked on

Printing to "Adobe PDF" Printer Crashes Microsoft Access

I'm using Adobe Acrobat 6.0 Standard Edition and I print to the printer named: Adobe PDF

This printer was installed during the installation of Adobe Acrobat 6.0 Standard - and works very well when I print to it from any application EXCEPT Microsoft Access 2002 (XP).  

We are running an application which was developed in Access, and each of our workstations has:

Microsoft Windows XP
Microsoft Office 2002 Small Business Edition
Microsoft Access Runtime 2002

All but one of the workstations have NO problems whatsoever..

When I try to print anything from the Access application to the Adobe PDF Port - Access crashes completely.

Here is what I've done:

I've reinstalled Adobe Acrobat, Microsoft Office, Access Runtime

Still can't do it from this machine.

Any ideas?

KGreg
Avatar of jjafferr
jjafferr
Flag of Oman image

Hi KGreg,

try

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=codearchive&Number=173380&Forum=f48&Words=&Searchpage=0&Limit=25&Main=173380&Search=true&where=bodysub&Name=17665&daterange=0&newerval=1&newertype=m&olderval=&oldertype=#Post173380&bodyprev=

and
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=access_2000&Number=117269

another post:
"I had a very similar problem, and the solution I found, at least for WindowsXP, was that you can reassign a printer port for the Adobe PDF printer to whatever folder you would like to save the files to. Then, when the file dialog box is disabled, the file will go to the folder you specified in the port setup, and the file will be named after the report itself.
Then, you can simply modify the code to look for the file in the right location and the specific filename, and you don't have to mess around with moving it if you don't want to."


I hope this helps.

jaffer
KGreg,

OR
try alternative way

www.almosawe.ae/jaffer/pdf-Report.zip
Avatar of KGreg
KGreg

ASKER

Thanks for your post.. However the problem is not in the method of PDF creation since it works on all machines except two..

The problem is that on 2 of our machines we can't use "Adobe PDF" as the printer because access will crash.

KGreg
Avatar of KGreg

ASKER

Also.. The "Adobe PDF" printer works well in any other application.

It only fails in access.

KGreg
KGreg

I propose you put a pointer to you question in the Adobe Acrobat section
https://www.experts-exchange.com/Web/Graphics/Adobe_Acrobat/

jaffer
Use the "Adobe PDF" printer, but check the "Print to File" checkbox. This will intercept the PostScript file that would otherwise be sent to Distiller. Does this still crash Acrobat? I don't propose this as a workaround, but this will help to narrow down what's causing this problem.
Avatar of KGreg

ASKER

I just tested your idea but it still crashes access..  Here's how I did it:

I opened our company application, went to one of the forms, clicked File->Print.  Selected "Adobe PDF" and checked "Print to File" within a second or two access crashed.

It doesn't get to the dialog that is shown when a PDF is being constructed.. pretty much just crashes when I hit the OK button on the Print dialog when the printer is set to "Adobe PDF"
ASKER CERTIFIED SOLUTION
Avatar of Karl Heinz Kremer
Karl Heinz Kremer
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KGreg

ASKER

I've added a new printer with the Apple Laserwriter PS driver.. and it works

I wonder why printers with the driver "Adobe PDF Converter" won't work for access?

KGreg
OK, that's good. Now do the same again, but this time browse to the driver in this directory:

c:\Program Files\Adobe\Acrobat 6.0\Distillr\Xtras
You will find five different PPDs listed. Select the first one (should be "Adobe PDF") and click on "OK", then continue as before.

Does this printer crash Acccess? (This should do the same as your Adobe PDF printer).
One more thing: Are you really running the version 6.0.0? If so, upgrade to at least 6.0.1, or better 6.0.2 (this does require that you have 6.0.1 first).
Hello KGreg,

Did you find a full solution to this issue? I am having the same trouble and from the discussion above I don't see the final outcome.

Please let me know what the final solution is if you have one.

Thanks a lot.
Avatar of KGreg

ASKER

Add a printer that uses the Apple Laserwriter PS driver (or any PostScript Driver.. they usually have PS at the end) and set its port to be a PDF port

This should work.

KGreg
KGreg, khkremer

Can I ask you guys to have a look at this post
https://www.experts-exchange.com/questions/21172357/Printing-MS-Access-Report-to-PDF-without-Save-As-Dialogbox.html

The author needs some help with
"Printing MS-Access-Report to PDF without Save-As-Dialogbox"

thanks

jaffer