Unanswered: Detect which records are being accessed
I have a backend that is accessed by multiple people. Currently I have a function that goes to the first record and then keeps going to the next record until the last record is reached. Along the way I trap the access error that occurs when the record is already locked by another user. Once this is done I display a message box with the record numbers where the records were being accessed.
And finally my question is, can this be done behind the scenes without me actually going from record to record? Hey, at least I don't click the next record button hundreds of times any more...
A majority of time people are accessing a record assigned to them so I can call them up and boot them off if I have to do maintenance. It is a minority of the time that a person just sits on a random record and then I have to send out an email to the whole company =(
I have a loop that "physically" loops from the first record to the next.
My trapping code works via the "on current" event. I don't think I will generate errors just by looping the record set. My thinking is I have to try and open each record for writing to generate the error that occurs when somebody else already has that record open... am i write or wrong?