Losing Printer Settings

D

DSmith

We have just upgraded to XP and Office 2003. Using an Access Database the
printer settings will not hold over a network for a label report. Keeps
defaulting back to Letter size. Any ideas?
 
D

DSmith

I tried that but it didn't solve the problem.

Allen Browne said:
First thing to check is this known bug, caused by Name AutoCorrect:
http://support.microsoft.com/?id=240826

It is important to get the update in that article, but you should also
know
that Name AutoCorrupt is very likely to give you further headaches if you
don't disable it. There's a partial list of the many bugs and crashes it
causes in this article:
Failures caused by Name Auto-Correct
at:
http://allenbrowne.com/bug-03.html
Click to expand...
 
A

Allen Browne

Okay if you have this turned off, here are 3 more ideas:

1. Open the report in design view.
Make a design change (such as renaming a label.)
Choose Page Setup from the File menu.
On the 2nd tab, choose Specific Printer.
Select the desired printed.
Then set the page size to the desired page.
Close the dialog.
Save the report.

2. If that still does not work, try exporting the report to a text file, and
importing it again:
Open the Immediate Window (Ctrl+G).
Enter this (replacing Report1 with the name of your report):
SaveAsText acReport, "Report1", "C:\MyReport.txt"
Then delete the report from your database.
Compact: Tools | Database Utilities | Compact.
Open the Immediate Window again.
Enter:
LoadFromText acReport, "Report1", "C:\MyReport.txt"

3. If that still doesn't work, delete the report, and create it in the new
version.
 
D

DSmith

I have created a new label report in Access 2003 and still the printer
settings will not hold when the database is copied onto another computer.
Paper size and margins change within the label report. I use the FEUpdater
to copy the database to the other computers. Thanks for your help.
 
A

Allen Browne

Yes, it will do that if you save the report for a specific printer, and then
copy the database to a different computer.
 
D

DSmith

But this is a network printer and is on all computers. Should the same still
happen??
 
A

Allen Browne

In perfect world, you might expect all machines to recognise the printer as
the same one.

In a Windows world, there are likely to be slight differences in the printer
driver or setups, and the software is likely to think it's a different
printer, and behave as you describe.
 
Top