How to Monitor a folder and write log to a .txt file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, Friends:
I am trying to write a vb/vba program to monitor an important folder, the
program will take down userid who change the file, create file... filename,
time into a .txt file. I consulted previous postings, however, all of them
are about how to monitor the change on a table/database.
Anybody can give me some suggestions?

Thank you in advance for your help!!!!!!!!!!!!!!!!!!

Pascal
 
hi Pascal,

Pascal.H said:
I am trying to write a vb/vba program to monitor an important folder, the
program will take down userid who change the file, create file... filename,
time into a .txt file.
Click to expand...
Why do you want to do this in VBA?

You have to options:

Poll the directory or implement an API function how monitors your folder.



mfG
--> stefan <--
 
Hi, Stefan:
thank you!
But I do not know how to poll the directory, or how to implement the API. Do
you have sample code, or general procedures?

Pascal
 
hi Pascal,

Pascal.H said:
But I do not know how to poll the directory, or how to implement the API. Do
you have sample code, or general procedures?
Click to expand...
Both are quite complex methods. So why do you want to do this?


mfG
--> stefan <--
 
Hi, Stefan:
It has part of auditing purpose. I need to monitor activities in that folder
so that I can keep track of what happen if some events/malfunctions happen.
The folder contains important data which feeds our application, an Access VBA
application. So, my first thought is if we can do it in VB/VBA. However, I
will also consider other languages if they are easier to do so, but I need to
know the methods.

Thank you

Pascal
 
hi Pascal,

Pascal.H said:
It has part of auditing purpose. I need to monitor activities in that folder
so that I can keep track of what happen if some events/malfunctions happen.
The folder contains important data which feeds our application, an Access VBA
application. So, my first thought is if we can do it in VB/VBA. However, I
will also consider other languages if they are easier to do so, but I need to
know the methods.
Click to expand...
Take a look at

http://www.mvps.org/access/modules/mdl0053.htm


mfG
--> stefan <--
 
Back
Top