By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Auto Detect New file On FTP Site

P: n/a
Hello,
I am currently running a dos based FTP commands to grab a file at a
certain time
and then it imports it into access and updates accordingly.
The problem is that I have this set to run at specific times, and if
the new file is not present the application fails, etc.
What I am looking for is a way to have the FTP app periodically (
every 5 minutes) check the site and folder for new files.
If a new file exists do one thing, else just quit and check again ...

Any ideas?
thanks in advance!
Aaron
ac******@alleghenyps.com
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ac******@alleghenyps.com (Aaron) wrote in message news:<ae*************************@posting.google.c om>...
Hello,
I am currently running a dos based FTP commands to grab a file at a
certain time
and then it imports it into access and updates accordingly.
The problem is that I have this set to run at specific times, and if
the new file is not present the application fails, etc.
What I am looking for is a way to have the FTP app periodically (
every 5 minutes) check the site and folder for new files.
If a new file exists do one thing, else just quit and check again ...

Any ideas?
thanks in advance!
Aaron
ac******@alleghenyps.com


Nothing doing.
Leavve a form open that has a timer on it. IN your ontimer event,
check for the existence of the file. (use the Dir command). I think
it's documented on datafast.cjb.net or www.mvps.org/access
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.