I have a two page report that contains one subform and 2 subreports. I am attempting to duplex print it on either an HP 8150 or a Xerox Workcentre M55. Everytime I print it, it begins spooling and printing, but then I get an msaccess error and the program shuts down.

I have tried different drivers for both printers. I have tried different computers. I have tried different operating systems. All have the same problem.

Please help.

Try making this into a subreport.

What is the exact error? Have you compiled your database and preformed a repair and compact?

The exact error is "msaccess.exe has generated errors and will be closed by windows." I am currently running Windows 2000. I am using an Access Project that has been compiled and is in .ade format. I have compacted and repaired the original database file, but that did not help. I will attempt to turn the subform into a subreport, but would like to know if you have any other thoughts.

Does it crash when you print regularly (no duplex)?

On this report, yes, it crashes with or without duplex. Other than this one report, I have had no problems like this.

Try these commands from the immediate window:
saveastext acReport,"Report Name", "C:\rpt.txt"

Rename your existing report then run this command
loadfromtext acReport, "Report Name","C:\rpt.txt".

You may need to execute this for the main report and all sub reports.

Okay, I did what you recommended and tried to print. It worked.

First, thank you.

Second, why?

I am assuming, perhaps just that report or one of its subs must have been just a little corrupt. Then I'm guessing you had me convert the report and its subs to a text file and reimport them back into the database, with the hopes the corruption would be lost when it was converted/reimported. I would love an explanation though.

By the way, THANK YOU again.

You are correct with your assumption. As for an explanation of how and why, I don’t have one - these things just happen.

Glad I could help.