Locked Record

G

Guest

Good morning,

Could someone show me how I can using an event detect if the active record
has been locked by another user.

Is there a way to determine which user has locked that specific record?

Thank you for the help!

Daniel
 
A

Alex Dybenko

Hi,
what you can do - is to try to lock this record (say open recordset in
locked mode) - if you get an error - then record is locked already
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

record locking 1
Could not update; currently locked (updated post) 6
Error: Argument Not Optional 0
could not update, currently locked 4
Record locking - Integrating Access with Sharepoint List 1
Checking a record for record locking 1
Detect if record already locked by another user 0
Err 3218, Could not update, currently locked Access 2007 Sharepo 1

Top