How to speed up program processing

[Tony Girgenti]

I'm having a problem with an AccessXP program using externally linked tables
thru ODBC. The program works fine with a small amount of test data in the
tables(couple hundred records in each table). When i attempt to use it on
live client data, it runs for over 24 hours and never finishes. We have to
terminate it by using Task manager/applications(alt-ctrl-del). It uses 100%
of the resources, shows in task manager as not responding. The following
tables and their record counts are used.

Customers 27,069
Items 2,698
Order Headers 92,502
Order lines 159,366

I'm running it on a new DELL Dimension 2350, 2.0ghz, 256meg RAM, 18gig HDD

The program is pretty simple. It creates an export file and optional report
using:
DoCmd.OpenReport strcReportName, acViewPreview
DoCmd.TransferText acExportDelim, , strcQueryName, strFile

If any anybody has any ideas on how to speed this program up or how i can
track the progress of the query, i would greatly appreciate it.

Thanks,
Tony

 

[david epsom dot com dot au]

Which line is blocking? The report or the export?
Is it the report/export that is blocking, or is it the query?
What happens when you try to open the query without using
the report/export?

(david)