[AccessD] FTP Accdb File

I've used the binary setting successfully to FTP sometimes when things
didn't transfer as expected. The default if you don't specify that with
many ftp tools is ascii and so any characters outside of the ascii range
can be corrupted.

GK


On Mon, Sep 2, 2013 at 2:28 PM, David Emerson <newsgrps at dalyn.co.nz> wrote:

> Brad,
>
> Try zipping the file first and using the FTP, then unzip it at your end to
> see if this makes any difference.  Sometimes I have found that files get
> corrupted if they are not zipped.
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Tuesday, 3 September 2013 7:17 a.m.
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] FTP Accdb File
>
> John,
>
> Thanks for the help.
>
> I made sure that the Access file was not open and I tried the FTP again.
>
> I received the same results.
>
> I then looked for an unblock button but I could not find one.  I am not
> downloading a folder, just a single accdb file.  I am using XP SP3.  I
> could
> not find any unblock option at the file level.
>
> I plan to do some more digging into FTP as I wonder if there is some
> parameter that I need to specify for either the upload or the download.
>
> Thanks again,
> Brad
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com on behalf of John Bodin
> Sent: Mon 9/2/2013 1:04 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] FTP Accdb File
>
> Was the database open when you did the FTP?
>
> Also, it is possible the file is "blocked" since it came from an external
> source so you may have to right-click on the file in the destination
> folder,
> go into Properties and hit the Unblock button.
>
> Those are two quick things I can think of.
>
> John
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Monday, September 02, 2013 12:04 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] FTP Accdb File
>
> All,
>
> I am trying to transfer an Access 2007 "accdb" file from a remote computer
> to a local computer.
>
> I am using a script that uses Windows command line (ftp.exe).
>
> Both the upload and the download appear to work properly.
>
> However, when I try to open the downloaded .accdb file, I receive a message
> that the Access 2007 accdb file is in an inconsistent state.
>
> I have not used FTP a lot.  This is the first time that I have tried to use
> FTP for an accdb file.
>
> Has anyone else ever used ftp.exe to transfer accdb files?
>
> Is there some ftp parameter that must be specified to make this work
> correctly?
>
> Thanks,
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> This message was scanned by ESVA and is believed to be clean.
> Click here to report this message as spam.
> http://h0stname/cgi-bin/learn-msg.cgi?id=EDF7728899.C4872
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com