File Monitoring

S

SandySun

Does anyone know of any good file monitoring software/programs that I can use
that is compatible with Access. I have several macros that I would like
executed if certain files appear in certain folder. Or is this something
that I can do programically within Access? Any help is really appreciated.
Thanks!

Cheers
 
D

Daniel Pineault

You could create a form that would launch in hidden mode when your db is
opened and use it's timer event to regularily run a routine which checks for
your file(s) and then take the appropriate action when found.

To check for the file you can use the 'FileExist' function found at
http://www.devhut.net/index.php?lang=en&id=0000000027#TestExtFile
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
S

SandySun

That's interesting Daniel.....however, what I am trying to do not have
anything happen until a file is present.....I have quite a few processes that
should happen as certain file become available in certain folders.....and to
have Access checking every 5min until something is available may me bit much.
Any other suggestions?
 
Top