up**********@ho tmail.com (Upendra Agnihotram) wrote in
news:9e******** *************** ***@posting.goo gle.com:
I am having Client-Server Access application. . . .
Meaning an MDB file connected to SQL Server?
Or an MDB front end and an MDB back end?
If the latter, then Client/Server is not involved.
. . . The source db . . .
The data MDB or the front end that the users are opening?
resides on WinNT Server and some of the client systems are on
Windows 2000 Professional. These days i am experiencing frequent
corruption of the source database (nearly 3 to 4 times a day)
which is on NT Machine?. Please let me know if there is any
solution for this
First, the application should be split, with the data MDB on the
server and an individual copy of the front MDB on each workstation.
Until that's the case, everything else is a waste of time.
Second, make sure that all workstations have Jet 4 SP6 or higher
(you don't say what version of Access, but problems mostly happen
with A2K and higher; also, Jet 4 SP8 is OK, too; if it's A97, then
you should have Jet 3.51 SP3), and the Access installations should
all be at SR1a or later if it's A2K and at SR2 if it's A97.
If it's A2K2 or A2K3, I don't know what the service release
situation is.
Brendan pointed out the oplocks issue, but in my experience, it's
not likely to help.
And for what it's worth, I had a client with all Win2K workstations
working with A2K data stored on an NT 4 server and there were never
any problems *once the Jet service packs and Access service releases
were in place on all workstations*. And it's *all* workstations --
even one workstation that is unpatched can cause the corruption.
I would not start worrying about hardware issues until all these
previous issues have been resolved.
Why?
Because, in general, working hardware doesn't tend to fail in a way
that would spontaneously start causing corruption. The problem is
much more likely to be a software issue, and the server is the
common point and the first place to start diagnosing.
Of course, if the workstations have automatic Windows Update in
place, they could all have gotten a patch that is causing the
problem.
Or it could be Norton Antivirus updates or some such.
But start by making sure your Access application architecture and
Access software infrastructure is in order before wading into the
muck on these other issues.
--
David W. Fenton
http://www.bway.net/~dfenton
dfenton at bway dot net
http://www.bway.net/~dfassoc