Access opening and closing for 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???

[Allen Browne]

Answered in microsoft.publis.access