Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    636
    Thanks
    0
    Thanked 0 Times in 0 Posts
    There is probably an easy way to do this. Does anyone know how to determine if a record is locked in Access 2003 using VBA?
    Regards,
    Peter

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I have not tried to do this, but looking around I found this

    It assumes you are dealing with a form. The code tries to edit the record in the form's recordset. If the record is locked that will generate an error.
    So if the error occurs the record is locked. If the error does not.
    The code in the link goes on to tell you who has it locked, but you could ignore that bit.
    Regards
    John



  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    636
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks John.
    That solution seems just the thing. I'll give it a go.
    Thanks again.
    Regards,
    Peter

Posting Permissions

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