TS Environment: get users who have opened a file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fpsoft - 16 May 2007 00:25 GMT

In a Terminal Server Environment (Windows 2003) i need to know the names of
the users who have opened a specified file (in my case it is an .mdb Access
file).

I know this isn't an easy task, because some google search pointed me to
nothing.

Is there anyone who can give me a hint?

Thanks.

Reply to this Message

Dave O. - 16 May 2007 10:05 GMT

You might be able to parse the LDB file which is created while the MDB is
open.
There is a potential problem with stale LDB files so you may want to have
something to delete the LDB file if one still exists when the MDB is not
open.
A more accurate way would be to ask the file system but I don't have the
faintest idea how you would go about doing that.

Dave O

> In a Terminal Server Environment (Windows 2003) i need to know the names
> of the users who have opened a specified file (in my case it is an .mdb
[quoted text clipped - 6 lines]
>
> Thanks.

Reply to this Message

fpsoft - 16 May 2007 13:03 GMT

The problem is that in the .ldb file i don't have the account name but only
the machine name and generic "admin" login.

Thanks.

> You might be able to parse the LDB file which is created while the MDB is
> open.
[quoted text clipped - 15 lines]
>>
>> Is there anyone who can give me a hint?

Reply to this Message

Mark Yudkin - 20 May 2007 08:58 GMT

1) NetFileGetInfo (for remote client access)
2) http://www.microsoft.com/technet/sysinternals/fileanddiskutilities.mspx

> In a Terminal Server Environment (Windows 2003) i need to know the names
> of the users who have opened a specified file (in my case it is an .mdb
[quoted text clipped - 6 lines]
>
> Thanks.

Reply to this Message

VB Forum / Win API / May 2007

TS Environment: get users who have opened a file