For Nikos or Anyone: Who's In a File

[LarryP]

Your post to another about the Environ("UserName") feature
may be the answer to a prayer, but not quite clear on it
yet. I've checked and confirmed that it works in both
Access and Excel VBA, but it returns the user of the
currently open file, i.e., me. Two questions: if I want
to know who's in a file OTHER THAN the one currently I'm
working in, can I do that? And if SEVERAL people are in
that other file, what does the Environ("UserName") return?

 

[Douglas J. Steele]

All Environ("UserName") returns is the user logged into the workstation on
which the command is run.

 

[Guest]

Bummer! Any idea how I can find out who or who all
(environment username would be fine) is using a file out
on our network? One of my coworkers has a utility called
FileSpy that works fine on his computer but not on mine,
and we haven't yet been able to figure out why.