97 converted to 2000 becomes very, very slow

[Ron Miyashiro]

I have a whole bunch of Access97 databases which we are
converting to Access2000. Most of the converted simple
ones perform okay. Of course, a few will need more
attention.

In the status space at the bottom of the screen, I see
more 'Calculating ...' and 'Running query'. And this
really slows down the performance of a few of my
databases. The databases, in Access97, ran fine.

Is there any way I can find out what is being calculated
and what queries are being run?

Just opening tables in Access2000 is slower than in
Access97.

Also running queries with linked tables also become
somewhat slower.

Are there options I can turn off to speed up the
performance?

Any help I can get will be greatly appreciated by me and
my users. Thank you.

 

[Tony Toews]

Also running queries with linked tables also become
somewhat slower.

Are there options I can turn off to speed up the
performance?

The three most common performance problems in Access 2000 are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

If the problem is for everyone when starting up the MDB then it likely
needs a decompile.

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm