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 / Multiuser / Networking / September 2003

Tip: Looking for answers? Try searching our database.

Access 97 Database Corruption

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Eric Hepler - 26 Sep 2003 18:24 GMT
Hello,

I have a back end Access 97 Database to a Visual Basic
application.  The application is used by about 20 people.  
The application and database both are on the network.  The
Access DB is comprised of linked SQL tables.  The database
itself is only about 4MB.  For the past 6 months or so we
have been dealing with the database getting corrupt about
5 or more times a week, at different times, by different
people, etc.   Any quick guesses?  I realize it could be 1
of many many different things.  My last guess is that the
server we have the database on gets a lot of heavy traffic
by many huge processes running every day, which could be a
problem? Please help if you have any suggestions, thanks
Tony Toews - 28 Sep 2003 00:33 GMT
>I have a back end Access 97 Database to a Visual Basic
>application.  The application is used by about 20 people.  
[quoted text clipped - 8 lines]
>by many huge processes running every day, which could be a
>problem?

Heavily loaded server could be a cause.

I'd also visit the Corruption Causes page at my website to see if
anything sounds like a match.   The OpLocks problem is much more
likely in A2000 though.

Tony
--
Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
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.