Sending PDF files via FTP

[KarenGilmurray]

Hi All

I am creating reports (containing a chart) which I output as pdf files using the code below:-

DoCmd.OutputTo acOutputReport, PrintDocName, acFormatPDF, Me!PDFName, False, , , acExportQualityPrint

This works fine - file is produced and can be viewed correctly.

I then use the shell command to ftp these files to a web site:-

Shell "ftp -n -i -g -s:" & Me!Defaultfolder & "\FtpComm.txt " & vFTPServ, vbNormalNoFocus

Again this works fine, the files are uploaded.

But if I download these files and look at them they are only partly there - sometimes the titles are gone, sometimes the scales, sometimes the data. It's very inconsistant.

Am I doing something wrong? Since the files are created ok and are viewable on my pc I think this part is ok. So I'm guessing that something goes wrong during the ftp upload though I can't imagine what - the files are quite small and surely ftp doesn't care what's in a file - it just sends it?

Any ideas anyone?

Thanks.

Sorry - I'm using Access 2010.

 

[KarenGilmurray]

I've resolved my own query - it was quite simple really. You need to set FTP to send the file as binary rather than the default of ASCII. Now it all works beautifully.