VBA Program runs slowly

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
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
 
Back
Top