Test if another user is in same record

[Scott]

Hi all,
Just wondering if anyone knows if it's possible to test (as User number
two 'enters' or navigates to the next record (not field) on a form) for
whether there is already another user (User number one) is already 'in' that
record on their PC?

If it is possible, any help with showing me how to do it would be greatly
appreciated.

(I have a courtesy call tracker form, which may only have 50 records, that
will be 'worked on' by up to four users at the same time. I don't want two
users trying to courtesy call the same person at the same time, so want to
test for 'simultaneous' access, and notify the 'second' user that someone
else is already on/accessing that record.

Thanks in advance!
Scott

 

[Allen Browne]

Access doesn't give you this, so you would need to roll your own.

Create a logging table. Use the Current event of the form to log the fact
that the user is viewing that record, and that they are no longer viewing
the previous record in that form. You will also need to use the Unload or
Close event of the form to log them out of the last record they viewed.

 

[Scott]

Hi Allen,
Thanks for that. - How's life over in Sunny Perth? Not so sunny
here in Melboourne ATM, 'cos of all of the smoke haze!