Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Veriftying ftp downloads

Discussion in 'Information Technology' started by rdemyan via AccessMonster.com, Jul 28, 2006.

  1. rdemyan via AccessMonster.com

    Guest

  2. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    "rdemyan via AccessMonster.com" <u6836@uwe> wrote in message
    news:62436829244e5@uwe...
    >I have code that downloads .xls or .mdb (tables only) files from an ftp
    >site.
    >
    > Should I be trying to verify that the downloads were accomplished error
    > free.
    >
    > If so, how.
    >
    > Thanks.


    I agree, the above is a problem, since error checking on ftp is weak, if
    present at all.

    I update my clients files all the time via FTP, and I experienced a few
    problems.

    I would consider zipping the file. Then when you un-zip the file, if the
    data is corrupted, then *usually* the zip utility will tell you this....


    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     
  3. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "rdemyan via AccessMonster.com" <u6836@uwe> wrote:

    >I have code that downloads .xls or .mdb (tables only) files from an ftp site.
    >
    >Should I be trying to verify that the downloads were accomplished error free.


    You could also compare the file size although Zip would be better as
    it does CRC checking.

    There are some file size API code at either the API section at the
    Access Web at www.mvps.org/access or vbnet.mvps.org.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  4. rdemyan via AccessMonster.com

    Guest

    Thanks for the replies.

    Unfortunately like many other businesses, zip files are now removed from any
    e-mails received.

    Tony Toews wrote:
    >>I have code that downloads .xls or .mdb (tables only) files from an ftp site.
    >>
    >>Should I be trying to verify that the downloads were accomplished error free.

    >
    >You could also compare the file size although Zip would be better as
    >it does CRC checking.
    >
    >There are some file size API code at either the API section at the
    >Access Web at www.mvps.org/access or vbnet.mvps.org.
    >
    >Tony


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
     

Share This Page