[AccessD] FTP Accdb File

Back of my mind...something about specifying binary transfer...but that may
have been from the previous century...

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Monday, September 02, 2013 12:29 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] FTP Accdb File

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