Check for a locked record (1 Viewer)

[mloucel]

You never told us what problem you are trying to solve. Access has no problem with record locks. What are you trying to do "better"?

Hey Pat.. Actually I did this it is in my original post:
quote:
"
(1) why should I NOT use:

"Default Record Locking = Edited Record"

and

(2) how can I check and display a message to the EU (End User) if that record is locked ... (Using VBA of course) "

End Quote..
my main concern was #2, I found a solution, is not perfect, I am applying that to my database, once I make it work, I'll post the solution (to #2) and hopefully someone else can make it work better that I can.

Thanks.

Maurice.

 

[Pat Hartman]

That isn't a problem. It is a question. Access handles locked records correctly without any help from us. Extremely few applications actually run into contention anyway. Were you having a problem due to contention?