Access suddenly very slow

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Hard to say reason, but here are some things to try to
isolate the problem:

1) make copy of remote attached database and install and
attach locally and see if speed changes dramatically
2) run queries behind forms to see what their performance
is online without forms involved
3) make sure your tables have keys based on the fields you
are linking with in the remote databases
4) have you run the program from other machines with the
same problem?
5) have you run the Windows performance monitor and looked
at what is going on when you make a request (CPU jumps to
100, etc)
6) Create a new empty database and copy all objects from
current program database to new empty database and test
performance
7) Create a new empty database and pull objects a few at a
time and monitor performance at each phase. If performance
goes down the tubes at a phase, check all the objects
pulled in that phase.
8) look for timer events in forms that may be running code
that is slowing you down
9) Try running on a 2000 machine; XP stinks, I know, my
laptop won't run anything else. If it runs okay on 2000,
check the Microsoft Update site. Some XP security updates
cause problems with performance.

Can't think of anything else off the top.

Keith
 
Keith,

Thanks for all the suggestions. Some I have already tried
some not. Best bet seems to be to create a new database
and copy items in. My IT guy insists that the problem is
not on the server side. Slowdown happens on other peoples
machines also so it is either the server or the database.
I'll have to play around. Great way to learn Access, even
if I don't want to. :-).

Bruce
 
Bruce said:
Keith,

Thanks for all the suggestions. Some I have already tried
some not. Best bet seems to be to create a new database
and copy items in. My IT guy insists that the problem is
not on the server side. Slowdown happens on other peoples
machines also so it is either the server or the database.
I'll have to play around. Great way to learn Access, even
if I don't want to. :-).

Bruce
Click to expand...

Bruce,

You are one of *many* people with this same problem My guess is that the
Server was upgraded to W2K SP3 or greater recently. Microsoft is
unfortunately ignoring this problem. But, after months of questioning,
searching, etc. I found someone who quite by accident discovered that the
Office Startup Assistant, which supposedly speeds up opening Office apps,
may be the problem. Search for instances of the shortcut to it in your
Startup folders by entering "Office Startup*" WITH the quotes in the Search
for Files or Folders box and DELETE them, then restart your machine. After
hearing about this I had a customer who has been reporting this slowness
issue to me try it and so far he has not compalined about slowness since!

Ron
 
Back
Top