Upgrading to Acc2k from ACC97 and performance issues

[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????

 

[Scott McDaniel]

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.

 

[Tony Toews]

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????

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