Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auditing NT network users when accessing excel file

Status
Not open for further replies.

kings23

MIS
Sep 5, 2002
25
0
0
US
Does anyone know how to audit network users when accessing an excel file from a network share into a .txt file or something? I need to track users who access this excel file throughout the day to determine who is looking at it. Network is Windows NT 4.0 and I can see the users who have the file open in server manager but I can't continusously check that to see who has it open. Users access this excel file from a shortcut located on their desktops.
Thanks
Brian
 
Doing this with the network server can be a real resource hog. Have you considering adding an "on open" macro to the file in question? Possibly you could write it to capture the homedir path to a text file and keep adding it to it. Just a thought to keep resource hogging of your server down to a minimum.
 
FYI in case you don't care about server resources, it's on the server console, get to the file and right-click on it.

Security Tab - Advanced button - auditing and go from there.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top