[AccessD] FTP

John,

  I use two different approaches:

1. Older code VBA based which uses the built-in Microsoft FTP client.  I
script a batch file, execute it, wait for it to finish, then parse the
resulting log file.  I have procedures for Uploading, Downloading, Fetching
a directory list, and deleting FTP files.

   I like this approach because it's simple.  No installation worries and I
can troubleshoot very easily as what the code does is exactly what I would
do from the command line.  It's not often I have problems with it.

2. I use the FTP Classes from Dev's web site.  I've used this quit a few
projects.  Cleaner to code by far then #1, but difficult to trouble shoot
when something goes wrong (pretty much always has been my mistake). There
can be installation issues as the code relies on WinInet.dll.  I did have
one client where FTP operations did not work through my app or IE, so I
swapped out the code for #1, which worked.  Never took the time to figure
out why.

HTH,
Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Wednesday, March 07, 2007 5:22 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] FTP

I noticed at least one person discussing monitoring directories and FTPing
up/down.  For those that do that, what method do you use for implementing
the FTP stuff?  I have been developing similar capabilities using 3DFTP
(which I love and recommend highly) and an API to program to it.  
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com