Access 97 runs slow...please dont hate me for asking this question...

[Mark]

Hi guys

I know, I know - access 97....

Yesterday was running fine, all looking good, then all of
a sudden the access database I am working on just started
dying - all functionality works but damn, it is so slow, I
mean so slow it hurts.

Its an old application running on access 97 which we are
about to upgrade to sql. Computer has win 2000 on it, and
access was installed over the top of newer access, service
patches installed, everyone kung fu fighting. I literally
cant think of what I have done - stop, restart and back
into it and baam.

ANy hints?

Mark

 

[John Vinson]

Hi guys

I know, I know - access 97....

Still probably the most stable and certainly the most disk-efficient
version of Access ever released.

Yesterday was running fine, all looking good, then all of
a sudden the access database I am working on just started
dying - all functionality works but damn, it is so slow, I
mean so slow it hurts.

Its an old application running on access 97 which we are
about to upgrade to sql. Computer has win 2000 on it, and
access was installed over the top of newer access, service
patches installed, everyone kung fu fighting. I literally
cant think of what I have done - stop, restart and back
into it and baam.

Check out the Microsoft Knowledge base at
http://support.microsoft.com. As a rule, if you're running mulitple
versions of Access, you should install them oldest first. It is quite
possible that you have clashing references to newer and older .dll
files. I don't have the reference handy, but there's an article in the
MSKB on the subject.