[AccessD] A2K: Determine what needs to be copied from FTP Location

Hi all

 

I am opening FTP connections from within Access by using the following syntax

 

Call Shell("explorer HYPERLINK
"ftp://username:password@somehost.com/"ftp://username:password@somehost.com” ,
1)

 

This opens things up in a normal windows explorer window – simple for dragging
and dropping – cool works well

 

What I want to automate is…

 

1        I need to determine the last file I copied from this FTP location to my
machine 

 

2        Then read from the FTP folder to determine what files are ‘new’ – i.e.
Files that have been put there since I did my last download (as per point 1)

 

3        Then once I have determined what files I HAVE NOT got – need to copy
them to a local folder on my machine

 

The files all have a sequential naming convention based on date – 

 

EG I may have downloaded to my local folders, all files up to and including
WDL320070312 (File created 12th March 2007)

 

But let’s say in the FTP location there are 3 files there I don’t have EG
-WDL320070313, WDL320070314 and WDL320070315

 

Need to determine these 3 files need downloading then need to copy these 3 files
locally

 

Make sense?

 

Any clues/suggestions? 

 

Many thanks in advance

 

Darren

 


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.11/723 - Release Date: 15/03/2007
11:27 AM