[AccessD] A2003: FTP and Network Connection Gurus

Hi Stuart
Can't get it to work <sigh>
It should be simple
All I see is a constant running (Like credits at the end of a movie but
really really fast) of text in a DOS window


DD

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Thursday, 9 December 2004 1:25 PM
To: Access Developers discussion and problemsolving
Subject: Re: [AccessD] A2003: FTP and Network Connection Gurus

On 9 Dec 2004 at 9:14, Darren DICK wrote:

> Hi All
> I need to add an FTP upload screen to one of my APPS
>  
> Firstly - lemme say I know nothing about such things The client's  
> Network dude gave me...
> A Server Name
> A UserName
> And a Password
>  
> So...I opened up an FTP client and successfully transferred the back 
> end of the app (About 4meg) to the FTP location he supplied with the 
> credentials he supplied - Phew so far so good :-))
>  
> Anyone got any code or forms or URL's they'd like to share so I can 
> incorporate something like an FTP scheduler in my app, to run nightly?
>  

You can do it by very easily by scripting a FTP session and scheduling it
using built in Windows capabilities (Look up FTP commands in WIndows Help):

Create a text file (c:\ftpstuff\myscript) containing the following,
substituting the appropriate info. Make sure that there are no trailing
spaces on the lines:

open ftp.myftpserver.com.au
myusername
mypassword
send c:\ftpstuff\myfile.mdb
disconnect
quit

Note:  This should work, depending on the FTP Server he is using.  Some
require a line like "USER myusername mypassword" in place of the two lines
with above.

Then schedule a one line batch file  containing the command:

ftp -s:c:\ftpstuff\myscript 

> Secondly how do I then link a front end to this FTP'd backend?
> I know the IPADRRESS of the FTP destination, but don't know the share 
> or what the 'true' location of the FTP'd file is
>  
> I have relinking code that can link to all the tables in say....
>  \\123.123.456.789\SomeShare\SomedB.mdb
> But how to I work out a path like that from the FTP info I have so far??
>  

You can't.  His FTP structure does not necessarily bear any resemblance to
the path which Access will use.  You will have to ask the recipient what UNC
path  the FE will access the BE through.


--
Stuart


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com