Re: "you and another user..."--standard fixes don't apply

On Aug 28, 4:28 pm, Jan <j...@xxxxxxxxxxxxxx> wrote:
Hi:

Here's a problem I've had for a long time.  The client is really running
out of patience, and I have no answers.

Access2003, front- and back-end.

Single form with 4 subforms (each representing a related table), 5-10
clerks doing data entry at one time.  Tables are quite large but all
work is done with unbound forms and/or local temp tables, and written
back to the server at intervals (I moved to that structure in the hopes
of solving this problem; it didn't seem to help).

The error is 3197, "The Microsoft Jet database engine stopped the
process because you and another user are attempting to change the same
data at the same
time."

It generally happens on one particular subform, but sometimes happens on
another one.  I believe it happens at the point at which the record is
written back to the main db on the server (from the local temp tables).
  The client is in California and I'm in Chicago so I can't watch them
work.  They won't give me the ability to log onto their individual
workstations to troubleshoot.  I can't reproduce the problem, either on
my computer here, or on the computer to which I do have remote access.

I have searched this problem and looked at all the proposed causes, and
none of them applies.

There are no Memo fields.
I have compacted, rebuilt the tables, written all data to new tables on
a clean blank database,   I believe there is no data corruption.
This error occurs intermittently.  They can go a few days with no errors
but then have them on every two or three records for a few days.
I believe that most of the clerks get the errors but that some don't, or
some get them less often.

Their server used to be horrendously slow; it's now somewhat better.
I'd love to blame it on their network connections, but without solid
evidence their IT staff is not going to accept that as an answer.

We are working toward switching to a SQL Server back-end.  I'd like to
think that will solve the problem, but if it doesn't I'm in deep trouble.

I have no idea how to fix this.

Can someone help?

I'd be happy to pay someone to take this thing apart and find the flaw.
  I sure can't see it myself.

Thanks.

Jan

Maybe the following standard fix will help:

PRB: Jet 4.0 Row-Level Locking Is Not Available with DAO 3.60

http://support.microsoft.com/?id=306435

James A. Fortune
CDMAPoster@xxxxxxxxxxxxxxxx
.

Relevant Pages