Performance

First off, I'm relatively new to Jet. I think it's a great tool.

One of my first jobs was to move an existing report off of Frx and onto Jet so that users couls use the report in the familiar app of Excel versus Frx which is not very user freindly for most.

The report is a cost center P&L that will be distributed via email through dynaics batch scheduling. All that is setup and working fine, except, that the report
takes about 24 hours to run. In Frx, it took about 4 hours. There are 110 jobs/rows within the batch job. One for every unique email recipient and/or cost center. The report gets emailed to all appropriate dept/cost center managers.

I;m looking for assistance in troubleshooting this performance issue. Where do I start?
Appreciate any recommendations. Let mek ow if there is further information required to help review this issue.

Excel 2007 | Jet 2009 | Great Plains connection to SQL Server 2000 Enterprise | Batch job runs off a desktop, XP Pro, 4GB ram, Pent 2.8 |

Thanks,

Andrew