File Monitoring

[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

 

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

 

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