Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Access Reports Records locked By Users When There Are No Locks

Access Reports Records locked By Users When There Are No Locks

Access Reports Records locked By Users When There Are No Locks

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 "lagging behind"
 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 "catch-up" command to
 the database?

Any ideas out there?

RE: Access Reports Records locked By Users When There Are No Locks

Which record locking restriction do you have on your tables?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close