Losing page setup

[DBinPhilly]

I have a customer who has been using a MS Access 2000 to run a package I wrote.
Occasionally and for no apparent reason the system will change the margins on some of the reports, thus making them overflow onto multiple pages.

I usually use .5 inch margins for the left and right, but when this problem occurs the system changes the margin to 1 inch, and suddenly my report doesn't fit on the paper.

In Access options I have set the print margins to .5 inches, but when this problem occurs I check and the options print margins have been reset to 1 inch.

Any ideas? This seems to happen in Access 2000 most often. I recently moved them to Access 2003, but I was told yesterday that again their reports are overflowing.

I'm hoping to move them to Access 2010 and maybe that will cure things.

Until then --- any ideas are welcomed.

[DBinPhilly]

I have finally been given remote access to the program and have learned that it did not change the margins.

It changed the orientation from landscape to portrait. This happens every few months, then I must go in to the program and change orientation back to landscape.

Only a few of the reports are landscaped. Most are portrait.

Any hints?

[HiTechCoach]

I would recommend compiling the front end into an MDE. This will prevent the report design changes from getting saved when the report can't find the printer is thinks it needs.

I often see this issue with MDBs and ACCDBs that are not split or the front end is shared. If any Workstation has a different default printer or do not have the printer that the report is set to use installed then the report usually gets reset to the defaults Also with a shared MDB/ACCDB, if one user changed the settings for their needs then this could easily get saved as the new settings for everyone. This can't happen with a MDE/ACCDE since report design changes can't be saved.

With a split database and the users was working on a copy of the front end, you can simply copy a new front end to get everything back. I split every database form the start. It does not matter id it is a single user on a stand alone PC or a multi-user on a LAN.

See: Splitting your Access database into application and data (http://hitechcoach.com/index.php?option=com_content&view=article&id=35:split-your-access-database-into-application-anddata&catid=65:split-database)


.

[DBinPhilly]

I, too split all my databases into front end /back end configurations. Just standard operating procedure for me.

however I will try an mde file to see if that helps.

This is actually a single workstation system, though some people come in through a CITRIX program using an internet connection.

thanx

[HiTechCoach]

Even with Citrix/Terminal Services I do not shared the front end.

Is the front end shared?