Access opens very slowly...

[Bill Engel]

I have a Microsoft Access 2000 database that resides on
our server. We have five users who gain access to this
database through a network drive. This has worked fine
for years.until yesterday. Now this database opens,
closes and performs every duty in between painfully
slowly. This database runs smoothly if opened on the
server upon which it resides. Further, I copied it to
one of my local workstation drives and it worked fine
from there. I have opened other files and other
databases residing on the same network drive and they
open fine. The database is only 32mb. I have already
compacted and repaired the database but that doesn't seem
to help. Our server is Windows 2000 Server and we are
running XP workstations.

The only thing that changed while this problem began is
that my workstation automatically downloaded and
installed WinXP SP2. It seemed to take forever for it to
download this file. There have been now other changes
and as a matter of fact, the number of people using the
database has decreased from 7 to 4.

As far as corruption goes, I have two concerns about
that: 1) If the database was corrupt, how could it be
opened on the server and 2) In the past if I imported
info into a new file, the code never went with it.

I have noticed also that my email is coming in very
slowly also. The Exchange 2000 server is on the same
server as the database. It seems that at times I don't
receive mail until I click mail that is already in my
mailbox. We usually get mail instantaneously. I am
wondering if the mail problem and the database problem
could be intertwined???

 

[[MVP] S.Clark]

Bill,

You are very brave to allow SP2 to self-install. You are now a pioneer on
the forefront of technology. Good luck.

I doubt that anything has happened to the mdb, and would focus the attention
towards any network changes. Any new anti-virus software installed. Did it
get SP2 also. If you have an IT dept, ask them what's changed.

 

[Bill Engel]

Steve, I am the IT department. Small company. No new
antivirus or any other software.

 

[Allen Browne]

If you have not checked out the Access Performance FAQ, that would be the
place to start:
http://www.granite.ab.ca/access/performancefaq.htm

 

[Pete Halasovski]

We saw something siimilar a few years ago; it turned out to be duff network
cards filling the network with rubbish. When we fixed the cards the problem
went away. Not saying this is your problem but it's certainly worthwhile
looking into network monitoring. I'd also suggest sticking a copy of the
database onto another workstation share to test if the problem is the
network or the server.

Hope this helps,

Pete

 

[Bill Engel]

Good idea. What is "duff" though...?

-----Original Message-----
We saw something siimilar a few years ago; it turned out to be duff network
cards filling the network with rubbish. When we fixed the cards the problem
went away. Not saying this is your problem but it's certainly worthwhile
looking into network monitoring. I'd also suggest sticking a copy of the
database onto another workstation share to test if the problem is the
network or the server.

Hope this helps,

Pete




.