Terminal Server and Access printing or saving files to users drive

D

DawnTreader

Hello All

i have a situation where i need to figure out the best way to handle the
printing of reports from my apps terminal server to the users printer. at
this point we have been using the standard terminal server printing back to
the users printers. the problem is that it seems so inconsistent.

at one point everyone could print, but we had problems with different paper
sizes and so i reformatted the reports to fit within both a4 size and letter.
the problem is that now it seems that no one can print.

i am not sure if this is an access problem, or if it is something with the
server.

i was thinking is it possible to print to PDF and then tell access to send
that to a particular folder on the users computer through access. i need to
have total security on the terminal server, so i would make it that the PDF
is transfered to a particular folder on the users C Drive. the user wouldnt
have a choice as to where so that the windows explorer save dialogs wouldnt
be available to them. it would just send the files to thier harddrive.

additionally i find that ever time a user connects, terminal server connects
to thier printer and leaves an "installation" of thier printer, so that
eventually there is multiple copies of the same printer for the same user,
sometimes as many as 20 copies. it is like the server isnt purging the
drivers after the user leaves the server.

if any one has any ideas or suggestions, please let me know.
 
S

Steve Schapel

DawnTreader,

I am not really an expert in this aspect. But I do know that printing
from Terminal Services to a local printer can be problematic.

I have successfully handled the situation by two means:
1. Print to PDF and then automatically email the PDF file to the user,
so they can they print it to their local printer from the email attachment.
2. Usint Net2Printer, which in spite of their difficult to understand
website at http://www.net2printer.com/ is actually a good and effective
product.
 
T

Tony Toews [MVP]

Steve Schapel said:
I have successfully handled the situation by two means:
1. Print to PDF and then automatically email the PDF file to the user,
so they can they print it to their local printer from the email attachment.

I've done this myself.

To the original poster:

Creating PDF files from within Microsoft Access
http://www.granite.ab.ca/access/pdffiles.htm

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top