By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,997 Members | 1,470 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,997 IT Pros & Developers. It's quick & easy.

Access opening and closing for very slowly

P: n/a
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???
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Answered in microsoft.publis.access
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.