Getting info on who is using a file on Windows...

[David Bolen]

bobh at hslda.org (Robert) writes:

> I am on a Windows network and I am trying to see who is connected 
> to an access database. 
> 
> I have been perusing the docs but nothing has jumped out and hit me 
> in the head.
> 
> Any ideas?

If the file is being shared via Windows networking, and you're using
NT/2K servers (not sure about other platforms), then Server Manager
for Domains (srvmgr.exe - installs with server OS versions, also
available in the resource kit) can connect to a machine and give you
information about open files and files in use along with clients.

That assumes that the access database is being accessed at the file
level across the network, and not via some client/server approach
where the actual file access is local on the server (I don't think
that's usual for access, but I don't have much experience with it).

--
-- David
-- 
/-----------------------------------------------------------------------\
 \               David Bolen            \   E-mail: db3l at fitlinxx.com  /
  |             FitLinxx, Inc.            \  Phone: (203) 708-5192    |
 /  860 Canal Street, Stamford, CT  06902   \  Fax: (203) 316-5150     \
\-----------------------------------------------------------------------/