[AccessD] A2003: FTP and Network Connection Gurus

William Hindman dejpolsys at hotmail.com
Mon Dec 13 06:38:29 CST 2004


..de nada ...glad you could make it work for you ...old hands here on 
AccessD helped me piece it together a few years back when it was my neck on 
the line, so I'm just passing the wealth along :)

William Hindman

----- Original Message ----- 
From: "Darren DICK" <d.dick at uws.edu.au>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Sunday, December 12, 2004 10:36 PM
Subject: RE: [AccessD] A2003: FTP and Network Connection Gurus


> Hi William
>
> Many many thanks works like a charm
>
> Stuart and Gustav - my most sincere thanks for trying to get a luddite
> through this
>
> I really appreciate your patience and your efforts
>
> Have a great day
>
> Darren
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: Friday, 10 December 2004 10:37 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] A2003: FTP and Network Connection Gurus
>
> Darren
>
> ..sent you off line a working mdb that imports a file from another mdb and
> then ftps it to a server on a schedule ...hth :)
>
> William Hindman
>
> ----- Original Message -----
> From: "Darren DICK" <d.dick at uws.edu.au>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Thursday, December 09, 2004 10:28 PM
> Subject: RE: [AccessD] A2003: FTP and Network Connection Gurus
>
>
>> Hi Gustav
>> Do you have a working example?
>>
>> After 5 hours - yes 5 hours - I give up
>>
>> DD
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
>> Sent: Thursday, 9 December 2004 8:14 PM
>> To: accessd at databaseadvisors.com
>> Subject: Re: [AccessD] A2003: FTP and Network Connection Gurus
>>
>> Hi Darren
>>
>> If you prefer a little more than a DOS box for the user to view, go and
>> pick
>> Windows Command Line FTP and the Access module to drive it:
>>
>>  http://www.pacific.net/~ken/software/
>>
>> /gustav
>>
>>>>> stuart at lexacorp.com.pg 09-12-2004 03:25:12 >>>
>> 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
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



More information about the AccessD mailing list