File Monitoring

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?

"Daniel Pineault" wrote:

> 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" wrote:
>
> > 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

You will have to poll for the presence of one or more of the target
files from Access.

If you are concerned about creating too much traffic you can use
various strategies to mitigate that issue:

1. If you *know* that a particular file will be the last to arrive
then test for the presence of just that file. Go into your routine
only when it's present. When all is said and done you'll have to keep
checking until the required files are all present.

2. Use some intelligence in your polling algorithm settings something
like: Check for the file(s) right now. If not present then divide
the time between Now() and the next 'drop dead' time after Now() into
two. Calculate the difference and set the next check time for the
mid-point in time. Keep the timer interval high enough to only check
the time 2 or 3 times before the next file check. Keep repeating that
process until the file(s) finally exist or you present your user's
with a process error message. To underscore the obvious, you would be
using the timer interval only to determine if the system time is at or
above the threshold you have set.

Remember to turn off the timer to facilitate debugging and turn it
back on when done.

HTH
--
-Larry-
--

"SandySun" <SandySun DeleteThis @discussions.microsoft.com> wrote in message
news:180B6A4A-FD15-4DB2-B149-16551C00467F@microsoft.com...
> 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?
>
> "Daniel Pineault" wrote:
>
> > 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" wrote:
> >
> > > 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