[AccessD] A2K: Using the shell() function

Hi Donald

Interesting approach!

/gustav


> Steve,

> I don't know if what I'm doing is similar to what you need to
> accomplish, but I've been working on a project that requires data
> capture via FTP.  I found a nifty program called WebDrive
> (http://www.webdrive.com) that allows you to map FTP sites as drives.
> In my db, I'm using a combination of VBA file manipulation functions
> (Dir, FileCopy, etc.) and Scripting FSO functionality to get and read
> text files via FTP.  You can refer to WebDrives using UNC or specific
> drive letters, and user names and passwords can be saved with the
> mappings so that they reconnect automatically upon system startup.  Best
> $40 I've spent in the last month or so . . .

> Hope this helps.

> Don McGillivray