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

[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

 

[Stefan Hoffmann]

hi Pascal,

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.

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 <--

 

[Guest]

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

 

[Stefan Hoffmann]

hi Pascal,

But I do not know how to poll the directory, or how to implement the API. Do
you have sample code, or general procedures?

Both are quite complex methods. So why do you want to do this?


mfG
--> stefan <--

 

[Guest]

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

 

[Stefan Hoffmann]

hi Pascal,

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.

Take a look at

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


mfG
--> stefan <--