How to speed up program

[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

 

[Larry Linson]

Doug Steele, in microsoft.public.access.odbcclientsvr, noted that he had
asked followup questions in yet another newsgroup and advised that you avoid
multi-posting. I will echo his advice -- if you feel compelled to put your
question in multiple newsgroups, please cross-post so people in all the
newsgroups will see the question and all the responses. But, as was pointed
out, one newsgroup is often enough.

Larry Linson
Microsoft Access MVP