Hi Dave The short answer is yes. Problem was due to users internet speed.
Solved it by giving the user a list box populated with the names of the tables that could be downloaded, some would not ever change. Pick the tables then it ftp'd these to c:\user\temp then proceed to zap the original and append from the temp file. Finally erased the temp files. But the ftp code has not been changed from yours. Thanks Peter -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Dave Crozier Sent: 26 September 2012 15:44 To: ProFox Email List Subject: RE: FTP Peter, Just found your post and I've been away on holiday in Italy for 10 days. Have you sorted out the problem yet? If not then drop me an email or post here. Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Peter Hart Sent: 15 September 2012 10:17 To: [email protected] Subject: FTP Hi gang I have a couple of problems, Ist for David Crosier's attention mostly. I am trying to get the FTP program working that is on Ed's download page. I have a need to update the data on each of the clients home worker machines The data sits on an SBS server at head office. And the home workers machines are automatically backed up to the server using SyncBackSE. One home worker cannot get a static IP so I wish to use your program to download and update her application. I have put your code into a form and also tried to run it as your prog. There are over 100 tables and indexes to download. Either way I run it its stops at approximately the 60th file and then gives a failure error. If I start the count at say 5 (For I - 5 To ALEN(.. It still fails on the same file. The file is called grp.dbf and the previous file is grp.cdx. The cdx file is quite a bit larger than the dbf, so I don't think it's the size of the file. Also will I have a problem with the fact that the head office router has a firewall rule to allow only certain IP's to FTP in. The Scotland satellite cannot have a static IP. Will the program still work and if not can anybody think of a way round this. Any help would be appreciated 2nd For anyone with any ideas. I want to use an edit box on the application update data form. To show a log of the files it copies down and whether each was successful or not. That is working but. When the log reaches the bottom of the edit box the edit box doesn't automatically scroll. Is there any way I can get it to do that. T.I.A. Peter Hart Peter Hart Computers. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
