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