Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / September 2004

Tip: Looking for answers? Try searching our database.

Access opening and closing for very slowly

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill Engel - 27 Sep 2004 13:49 GMT
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 - 27 Sep 2004 15:01 GMT
Answered in microsoft.publis.access
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.