David Emerson
newsgrps at dalyn.co.nz
Mon Sep 2 14:28:36 CDT 2013
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