Mark A Matte
markamatte at hotmail.com
Wed Mar 7 10:11:57 CST 2007
John, I use some older VBA code as well...I downloaded (or it was emailed) an example years ago and took out the parts I needed. There are no credits in the db...but the properties are locked out...not sure why. If you want a copy...email offlist. Thanks, Mark A. Matte >From: "Jim Dettman" <jimdettman at verizon.net> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "'Access Developers discussion and problem >solving'"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] FTP >Date: Wed, 07 Mar 2007 10:00:19 -0500 > >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 > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Dont miss your chance to WIN 10 hours of private jet travel from Microsoft® Office Live http://clk.atdmt.com/MRT/go/mcrssaub0540002499mrt/direct/01/