Track who goes into a folder

hey yer barred

Board Regular
Joined
Jun 19, 2007
Messages
232
Hi All

Im having a major problem here.

Someone has 'got it in for me' and deleting my work of servers. They do it everyday, 2 database and all reports templates for it. Now im getting the stick for it :(

So, is there anyway I can use VB6 or a excel sheet to track who goes into this folder and what they do....or even if it tracks who goes in it would be great.

We do have a log ID capture tool here....the coding is

Option Explicit
Private Declare Function Get_User_Name Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

Public Function GetUserName() As String

Dim lpBuff As String * 40

Get_User_Name lpBuff, 40
'Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)
GetUserName = Mid(lpBuff, 1, InStr(lpBuff, Chr(0)) - 1)

End Function


Please help me!
Thanks
J
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Are they erasing your data INSIDE your files?

Sounds like they are erasing the files. If they are erasing your files, there's nothing in VB that will help as they aren't entering the program so VB can't execute.

You need to get together with admin of your file server and get some utilities running that'll track all actions taken. But that depends on your OS and network environment.
 
Upvote 0
They are deleting the actual file in the folder.

It was a ling shot, but was hoping there might be some coding that could keep a constant watch on a file and tell me who deletes it.
 
Upvote 0

Forum statistics

Threads
1,225,363
Messages
6,184,518
Members
453,238
Latest member
visuvisu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top