Coverted to 2002 - Forms are now slow...

[Harris_Rodgers]

I mean super slow, like 5 minutes to load slow. What
could the problem be here? I've reset my references to
DAO 3.6 (I've also tried 3.51, but it didn't seem to make
a difference performance wise). I've also gone through
and added dao. to all of my database and recordset dims.
What could I be missing? This db ran fine in 97.

 

[Tony Toews]

Okay I just found this

Tools >> Options >> General >>.Track name AutoCorrect info
should be off.
Good.

Which helped a lot, but it's now still a little slow. Any
other suggestions? Thanks in advance!

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