Access runs slowly after upgrading to SP3

[Elena]

Running Access 2000 on Win XP workstation. Access database response time is
extremely slow. Same database's response time on a Windows 98 workstation is
substantially faster. Any suggestions for tweaks or fixes much appreciated.

Elena

 

[Tony Toews]

Running Access 2000 on Win XP workstation. Access database response time is
extremely slow. Same database's response time on a Windows 98 workstation is
substantially faster. Any suggestions for tweaks or fixes much appreciated.

You must mean Office 2000 SP3. Did the slowdown in performance occur
when you moved from Win 98 or when you installed SP3?

When moving from Win 98 to a Win NT line of OSs, such as Windows XP
the problem is almost certainly LDB locking which a persistent
recordset connection or an always open bound form corrects (multiple
users)

For more information on this, 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

 

[Elena]

Thanks for the suggestion. I will check tomorrow. The slowdown occurred
after I installed SP3 . Prior to this install, the database response time
was acceptable although not quite as fast as the response from the Windows
98 workstation.

TIA,
Elena