Office sp3 install reveals multiuser or database problem?

[JohnMc]

I recently installed the latest MS Office 2000 sp3 on a clients network.
These 10 workstations were running fine with the original install of
Office2000 until the upgrade was performed. Since sp3, some users are
complaining of slow response and performance problems. One user has the
habit of using ctrl-alt-del to exit the access FE software I created.
Reason: system hangs or is too slow to respond.

Does anyone know of problems with Office 2000 sp3 that could cause such
degradation in server performance? The identical software BEFORE the update
ran well but now can easily hang if 2 users access the same data or if a
random record is saved.

If it was db design, I would have expected this problem years ago as these
FE applications have been running for 4 years. Database is regularly
compacted. In an effort to solve this problem, I've used both Access db
compact utility and the jetcomp.exe program. I have no trouble with the
*.ldb file expect when the above user closes his system incorrectly.

Recent analysis of the forms and database reveal nothing except a suggestion
to index a minor field "stateAbbrv". I can't see why this small data field
could cause such degradation in performance.

Any comments or suggestions?

 

[John Vinson]

Does anyone know of problems with Office 2000 sp3 that could cause such
degradation in server performance?

Tony Toews has some good suggestions for general Access performance:

http://www.granite.ab.ca/access/performancefaq.htm

Make sure that Name Autocorrect is turned OFF in both front and
backends; and that all tables have their SubDatasheet property set to
[None] are two of the big issues in my experience.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps