Results 1 to 8 of 8

Thread: How to determine if the current record is locked?

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member Krass's Avatar
    Join Date
    Aug 2000
    Location
    Montreal
    Posts
    489

    Resolved How to determine if the current record is locked?

    In Access, I set the RecordLocks property of my form to "Edited Record". User-1 starts editting a record, but goes to lunch for 2 hours, leaving the form openned.

    User-2 browses to that record, but when trying to edit, the RECORD SELECTOR shows it cannot be editted because it's locked by the hungry user. Everything works well.

    I will now remove the record selector... How can I warn my user that he won't be able to edit that record? If he tries to edit the record, he'll end up with an error - which is normal. I would like to know how I can determine, by code, wheter or not the current record is LOCKED - I would then be able to disable some functionnality on that form (buttons and so on, which I don't want the user to use until the record is not locked anymore).

    It wouldn't be as accurate if I would just wait for User-2 to try a modification and catch the error resulting from that.

    I was expecting something like "msgbox Me.CurrentRecord.locked". (roughly)

    Thanks
    Last edited by Krass; Jan 13th, 2005 at 07:00 PM. Reason: now UN-resolved.
    Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width