VBA Program runs slowly

[Mark]

My program executes SQL statements from a VBA program.
It is fairly simple - it reads a record from a recordset
built by a query, and outputs the record several times to
a table.

All of a sudden it is executing very slowly. The CPU
usage averages about 25%.

Yesterday and all of last week (and the prior month) it
ran just fine, utilizing 100% of the CPU.

I have Compacted and repaired the database today. This
action has always made the program run faster when
the "slow bug" has struck, utilizing the 100% of CPU.

I did copy the database to a new directory today - but I
have done this often. The data coming into the VBA has
been updated too - but again this is something that has
been done in the past without a problem.

Thanks for your help,
Mark

 

[Mark]

Interestingly, the problem was trying to run the program
across the local network.

When the database was copied from the local network drive
to my desktop drive (C:\) it ran fast.

Mark

 

[Marshall Barton]

This might provide some ideas:
http://www.granite.ab.ca/access/performancefaq.htm