Upgrading to Acc2k from ACC97 and performance issues

  • Thread starter Thread starter Chedva
  • Start date Start date
C

Chedva

I had a mdb in Acc97 and I upgraded it to Acc2k(The user doesn't want XP b'c
he hax other systems crushing with XP). after converting the MDB everything
got to be much much slower (forms, queries ect.)
Why and What can I do or check????
 
For the record, I had a LOT more trouble with A2k than I have had with XP
.... matter of fact, I've had almost 0 problems with XP crashing, and it was
a regular event with A2k. Make sure your user has applied all the service
packs to his A2k installation ...

Check that the "track name autocorrect" has been unchecked (Tools - Options)
.... there are a few other performance items you can check, go to Tony Toews
site (google on his name to find his site) to run through the list.
 
Chedva said:
I had a mdb in Acc97 and I upgraded it to Acc2k(The user doesn't want XP b'c
he hax other systems crushing with XP). after converting the MDB everything
got to be much much slower (forms, queries ect.)
Why and What can I do or check????
Click to expand...

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

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