Processing time slowed down

M

Mark

I have a module that reads all the records from a table
and outputs them to a second table. This module when run
used all of the CPU (95%) as per the Task Manager.

I made changes to the input table - reducing the number
of fields from 23 to 22 - and of course changed the
module and ouput table to accomodate the fewer fields.

While Access runs the module without error. The time is
5 times longer and the CPU usage is way down according to
the Task Manager.

Any ideas as to why the slow down?

Thank you,
Mark
 
E

Elwin

I've found that while Access is running my CPU usage is
always high regardless of the complexity of the task. Is
your table indexed? It should have a primary key
defined. If that's not it you might consider posting the
relevant portions of your code for people to look over.
 
M

Mark

There is no index on the table. It was created using a
make table query from an indexed table.

The thing that is strange that the indexing part is no
different that last week and it ran fine (with high CPU
usage).

Since I changed the number of columns, it has started to
run slow.
 
J

John Spencer (MVP)

Could be a number of things, but the first thing I would try if you are using
Access 2000 or later is

- Track name AutoCorrect should be off
(Tools: Options: General Uncheck all name AutoCorrect features)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top