Paper layout keeps changing when database copied to a different PC

  • Thread starter Thread starter AAVF
  • Start date Start date
A

AAVF

Hi

We have a database that requires a group of reports to printed using the
'Legal' paper size. The database is regularly copied from a master on a
server to a local PC that runs the reports and does the printing.

Everytime I re-install the database on the PC, I have to go into the reports
in question and change their paper size from A4 to Legal, even though they
were set correctly on the PC where the database and the reports were created
and are maintained.

Any help would be appreciated.

Regards

Tom Millington
 
Tom

Any chance you're working with Access 2000? If so, have you applied the
latest updates? There was a known bug that messed with report settings --
the work around was to disable the Track Name Autocorrect in Options.

Good luck

Jeff Boyce
<Access MVP>
 
Hi Geoff

Yes, it is A2000.

We have SP3 for Office 2K on the PC in question, but no other updates. The
software vendor of our ODBC package has advised us not to load Office
updates as they cause more problems than they solve. We have heard this from
quite a few other people as well. I put a message on a newsgroup a couple of
days ago regarding Access and problems in printing and the responses I got
(direct from the ng and by email) were conflicting: one said I must have all
the latest updates and another said I should not load them.

Confused from Devon!

However, I will have a look at the workaround you suggest.

Regards

Tom
 
Hi Geoff

I have now applied all Office 2K updates, to see if that would help. Answer:
no, it didn't. I also checked to see if Track Name Autocorrect in Options
was disabled, yes it was.

The reason we needed this fix to start with is because the PC that creates
these reports occasionally prints garbage characters (issue I put on an ng
last week), so
I have designed my own workaround. We think the problem only starts when the
database has been used a few times, so I have written a batch file that
deletes the database and replaces it from a zipped master when the user logs
in. I found that even this method causes the paper size to be changed when
the new database is unzipped, so I have done the unzip, changed all of the
paper sizes to those required, then zipped it back again on the PC in
question and stored it on the PC as a master. So far, the paper sizes are
staying corrrect. I just hope the printing problem is cured as well.

Regards

Tom
 
Back
Top