By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,231 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Acrotray seems to lock up on printing reports

P: 74
I always have the same issue here and am wondering if anybody else does. I use adobe to print my reports to for ease of sharing with customers, and looking professional while doin it. The code i have sets the default printer to the "Adobe PDF" then commences printing. Since i set the name of the file on format, i have to actaully open the report in preview mode with
Expand|Select|Wrap|Line Numbers
  1. acViewPreview
Then i use
Expand|Select|Wrap|Line Numbers
  1. DoCmd.PrintOut
  2. DoCmd.Close
to print the report and then close.

All of this is done on a remote desktop (that matters in just a second). Here is the problem.

Everytime i first login to the remote, open access and print....Access hangs up, until i close acrotray.exe from processes, then it will continue printing the reports....normally(the way they were intended to print). If i try to print again, i have to do the same thing again.

My other option to finish printing is to actaully close Access (of course the prompt to repair the database...then tell microsoft about it). Once i do this, i can print anything just fine to Adobe, without any freezing, multiple times (this is the method i end up using, since it will print fine afterwards), until i log out of the remote, and log back in, so everyday, there is at least one lockup.

If anybody has come across this, or even has an idea about what to try i would be very greatful. Thanks in advance.

By the way, i have searched google, and cant seem to find even 1 relevant result.
Jan 23 '10 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072

Post your reply

Sign in to post your reply or Sign up for a free account.