Insanely slow behaviour

[Guest]

I have an Access 2000 program that is often incredibly slow to
do simple actions. For example, to delete one report took 70
seconds. To import/export one object can take 60-90 secs.

The db is quite large, and I don't expect instantaneous reponse,
but these times are way out of line.

I've tried to turn off 'Compact on close' and anything like that I
can find. I don't run any virus scanners.

When it starts up, you select the data file you want to use, and it
dynamically relinks the tables. There are about 100 tables to link,
and it wasn't dne in an hour.

The machine is a P500 with lots of RAM and W2K. Performance
on all other things is quite reasonable.

Any suggestions would be greatly appreciated.

thanks

Bert

 

[Paul Overway]

By far the biggest cause for issues with performance I've seen is not
keeping a recordset open once you've got at least one good table link in
your database. I suspect this is the problem you are observing given the
time it takes to relink. Having Name Autocorrect on is another.

See http://www.granite.ab.ca/access/performancefaq.htm for a variety of tips
to improve performance.