Slow conversion to RTF in Access 2007

[SteveG]

I was wondering if anyone else is having this problem. We recently upgraded
to Access 2007 (sp1) from Access 2003. We have several reports that we
convert to RTF files for display on our intranet. Since the cupgrade this
process that took 2 minutes now takes upwards of 20 minutes.

If we convert the report to PDF the process takes around 2-3 minutes,
Because we have several reports that we do this to we use the followng VB
code.

DoCmd.OutputTo acOutputReport, "Report Name", acFormatRTF, "File Name", True

One thing that has helped reduce the time is that we have removed the Page
numbering from the reports. This has helped but not a lot.

Does anyone have any suggestions?

Thank you in advance.
Steve

 

[H Miah]

I'm having problems outputting reports as RTF files using the OutputTo
method in VBA on Access 2007. Some of the commands take ages or freeze. I
wonder if you know a fix for this? Below is an example of the command I'm
using, which worked fine in the previous version:

Dim stReportName As String
Dim stFilePath As String
Dim stDate As String
Dim stDocName As String

stReportName = "Cohort_FollowupsSummary_LatestWeek_Qry"
stFilePath = "J:\Laura-Share\IID2\CCT\Data analysis\Weekly
reports_webdata\WeekMon_LSHTM_01C2_"
stDate = Format(Date, "dd-mm-yyyy")
stFileExtension = ".rtf"
stDocName = stFilePath & stDate & stFileExtension
DoCmd.OutputTo acOutputReport, stReportName, acFormatRTF, stDocName

Many thanks,
H Miah