Redirect Printer Output To Specific File

Hi, having nightmares with PDF again......

What I basically need to do is to set a printer in Windows to print to file and then programatically set the output file name at runtime.

In more detail.

I have set up a Postscript printer to print to a fixed file name.
In my code I set this to be the default printer.
I then print an Access report to this printer.
Once this report has printed I am using Ghostscript to convert the resulting printer file (which is in EPS format) to PDF.

This all works fine and has been for some time but I have now run into brick wall when this is used by multiple users using Remote Desktop because they are trying to write to the same printer output file.

Unfortunately this system is used on a number of different sites some of which are using Access 2000/2003 so I cannot use the new PDF options in Access/Office.

I am using the API WriteProfileString function to set the default printer.

Any help on this problem would be greatly appreciated.

Thanks

You'd have to change the name of the output file to reflect each user

Dglienna: I need to know if it is possible to change the name of the printer output file from within my VB6 project. Ideally I would use a randomly generated output file name each time as the files are only required temporarily while the PDF conversion takes place. The only possibility I can see at the moment is to set the printer to output to file and then use sendkeys to force the filename accross to the printer driver when it asks for the output filename. (Not ideal!!!)

Thanks

Well, VB.Net has a FileWatcher class that might help. You could monitor that folder, and move/rename as a separate operation.

I'd have to see the code that saves the filename.

Many printer objects do have the filename property...

I'm sure you can pass the filename to the object ...

Dglienna: Sorry but the problem with the multiuser environment is that multiple machines are trying to write to the same file at the same time so a file move operation would not be possible. I could check to see if the file exists first and then wait before trying to output the file but then if any of the machines fail to delete the file after conversion to PDF then the whole system would stall. I need to get the printer driver to output to a specified filename so that each machine can process files simultaneously.

Thanks

GremlinSA: Could you give me some more details, I am not actually directly accessing any printer objects, it is Microsoft Access that is sending the report to the printer driver and the printer driver is then sending the output to a file.

Thanks

If you tell the printer to PRINT TO FILE in it's setup, it will prompt for a filename

I am sorry if I have failed to explain the problem clearly, but I need my program to tell the printer which file to print to, my program uses this printer output file to generate the PDF file, so having the user enter a file name for the printer output file will not really be much use.

In essence I need to set a default printer (which I can do) and output to a specific filename that my program will generate.

Configuring the printer to output to file will ask for a filename (No good).
Configuring the printer to print to a static filename (Always print to the same file) causes problems in the multiuser environment.
My program needs to generate a unique filename each time (Like windows temporary files) and then configure the printer driver to output to this file before I generate the Access report.

I hope this clarfies what I am trying to achieve.

Time to re-think the design, I'd say...