Access Reports Records locked By Users When There Are No Locks

[drosenkranz]

I'm using VB 5.0 (Service Pack 3) and Access 97 DAO. The workstations are
running Win 95. I have as many as thirty five users on the system at peak-
most are browsers. Users occasionally come up with my error message which
will read "Record is currently locked by user JSmith" when attempting to save
their changes.

The problem is that the offending user, JSmith in this example, did not actually
have a lock on their records. In fact, sometimes the offending user is no
longer even on the system any longer when Access reports back their name as
still locking a record. Sometimes, the users are in separate (unrelated) tables
when this occurs too.

Actually, records are only locked for an instant when the user presses the
<Update> button. It almost appears that the Access table is &quot;lagging behind&quot;
the real time events- but I mean really behind. What causes this
behavior? Access? Network traffic?

Is there a command or setting that I could include (in a button) on the form
that will allow the user who is locked out to isuue a &quot;catch-up&quot; command to
the database?

Any ideas out there? [sig][/sig]

 

[ShortTexan]

Which record locking restriction do you have on your tables?