May 9, 2007 at 9:59 pm
I have an Access 2007 report, previewing on screen. The report can be up to 300 pages. When I click the ribbon button to send to Word 2007, it takes over two hours to create the rtf file. Both Access and Word are set to default to the 2003 file versions. This is a fast brand-new PC running Windows Vista Business.
The desired result is that the customer wants to "tweak" the report by
sending to Word and applying edits before printing. They do not want to
create a PDF and edit with a 3rd party tool. I suggested the PDF / XPS add-in but they don't want that.
When using Access 2003 and Word 2003 it takes a very short time to complete.
I should also mention they are running Trend Micro AV if that makes any diff.
Thanks,
Bill Mitchell
May 14, 2007 at 11:51 am
Trend could be causing this issue. Try excluding .mdb and .ldb files from being scanned.
Regards,
Matt
May 14, 2007 at 6:34 pm
Thanks Matt, for the suggestion. I detest Trend anyway, it sucks up too much CPU power. But the Access file runs just fine, it is only the RTF export that slows down. I'm going to try running the Sysinternals Process Explorer to see if I can figure it out. If not, I have "orders from headquarters" to revert to Office 2003.
May 17, 2007 at 1:17 pm
2 other thoughts on the subject (via another post that made me think of this). Send the reports via Access Snapshots (http://www.microsoft.com/downloads/details.aspx?familyid=b73df33f-6d74-423d-8274-8b7e6313edfb&displaylang=en is the link to the snapshot viewer that the recipients would need) or install CutePDF Printer on the local machne and print the files to PDF's and then email a .pdf to the end user.
Regards,
Matt
May 17, 2007 at 2:59 pm
Thanks again Matt. What they want to do is EDIT the exported report before it is printed, so snapshots wouldn't work. Ditto for XPS. I suggested PDF's and Acrobat, but they were already trying to learn Vista and Office 2007 at the same time, and didn't want to learn yet another program to edit PDF's. At the CEO's request, I removed Office 2007 and replaced it with 2003.
When they tried to export the 300-page Access 2007 report to Word 2007, they got tired of waiting & cancelled it after two (2) hours! After reverting to Office 2003, it takes about 30 seconds. I am not kidding about that.
BTW this is a 3.0 GHz Xeon dual-core with 4GB memory (makes me jealous) so it was defintely an Office 2007 problem.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply