I have some users when they change their default printer then some of the
reports in Access will not print out and give them an error. Why is this
happening and what can be done to prevent this?
There are a couple of different reasons this could occur. The
report(s) may be set up to print to a "Specific Printer" - check under
Page Setup if this is the case.
Also, check the margins on the report(s). Many printers have a minimum
bottom margin of somewhere between .5 and .6 inches. If your margins
are set too small you may get undesired results.
In Access, printer settings (page setup) are saved PER REPORT. In
order to absolutely prevent changes to the reports you can force the
reports to print to a specific printer (assuming this is desired for
your environment) and then compile the database to a .MDE file.
Compiling the database will make it so that printer settings on the
reports can not be saved - they can be changed for "on the fly"
printing, but what one user changes can not affect another user.
Also, consider splitting your database into front-end/back-end and
creating individual MDE files for each user to prevent multi-user
issues.
-Kris
