Does record-locking produce a VALUE somewhere in the depths of Access?

[databasis]

Does Access store a ‘value’ when it locks a record, or when a user tried to edit a locked record?

I have the form record locking set to ‘edited record’ so that one user can't edit a record when another is editing it. That's all very fine, but I need to find out if there is a VALUE stored somewhere just when the underlying record BECOMES locked by another user. Currently when a user realises the record can't be edited, nothing INDICATES this. All that happens is that the cursor can enter any text box but the user can't type anything anywhere. I'd like to do a check something like...

If Me.LOCKED = True Then
MsgBox "Try again later, please etc."
End If

If I could check for such a value I then could ALSO disable the all the command buttons on the form as well as the text fields.

This is not as simple as checking the AllowEdits property of the form. It's below the form level and I just don't know where!



Maria

 

[MichaelRed]

Maria,

The locking info is in the .LDB file. Look it up in the knowledge base. It is quite involved, and I would not even attempt to explain it.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over