S
Smokey Lonesome
I have an application in ACCESS that copies an EXCEL file from a common drive
on our network to the PC calling for it. I have error trapping set up to tell
me if that file is open by another user. The question I have is:
Is there a way to grab the computer name of the user who currently has the
file open so that I can display it an allow the person needing it to contact
the person locking it to get them to close the file?
Thank you in advance for your help.
on our network to the PC calling for it. I have error trapping set up to tell
me if that file is open by another user. The question I have is:
Is there a way to grab the computer name of the user who currently has the
file open so that I can display it an allow the person needing it to contact
the person locking it to get them to close the file?
Thank you in advance for your help.