[AccessD] Selecting a Printer, and dealing with Paper Types

Hello All,

Hope summer is treating you all well.  In Ireland, we currently have rain,
rain, and a little more rain.


I have an Access 2000 / 2002 / 2003 app that prints to a big HP printer with
four paper trays.  In the application, I call multiple reports in a
sequence, that eventually gives me a 27 page doc, printed on various paper
trays.  To facilitate this, I go into Page Setup, select specific Printer
and then select the paper type.  I then save the report and it remembers the
preferred paper type for that printer.  So far so good.

I recently tried to give access to the mdb file from other machines on the
lan, but I find that when I open the reports, it has reverted to using the
default printer.  I initially thought that what I needed was a network based
printer, that would be common to all machines, so I installed the driver on
a server, and shared it out and then changed the specific printer in Page
Setup to point to the Network  based printer.  But when I went to another PC
on the Lan, and opened the reports, they were switching again to the default
printer.

In summary, it looks like I have to programatically tell Access which
printer to use.  In my case, I only have 5-6 pc's to deal with, so I do not
need a 1000 user solution to this problem.

My choices are

1) tell the customer that they can only print from one machine
2) Split the db in to FE and BE and save the FE on each workstation and that
should avoid the problem occuring.
3) build a programatic solution, but from reading emails in AccessD, it may
not be so easy to get reliable.

Any thoughts on this ?

thanks

Mark