Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #13766 > unrolled thread

FTP a file(s) using MS Access

Back to article view | Back to comp.databases.ms-access

Contents

  FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-03 21:32 -0700
    FTP a file(s) using MS Access Mal Reeve <mal.reeve@gmail.com> - 2019-09-04 04:18 -0700
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 10:10 -0700
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 15:18 -0700
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 15:22 -0700
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-04 20:14 -0700
      Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-05 04:55 -0700
        Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-06 10:08 -0700
          Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-09 05:33 -0700
            Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-10 11:44 -0700
              Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-10 12:38 -0700
                Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-11 15:33 -0700
                  Re: FTP a file(s) using MS Access Ron Paii <ron81pai@gmail.com> - 2019-09-12 06:04 -0700
                    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-12 14:39 -0700
                Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-16 12:03 -0600
    Re: FTP a file(s) using MS Access samxjones2@gmail.com - 2019-09-05 06:11 -0700
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-05 14:46 -0700
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-05 14:57 -0700
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-06 12:06 -0700
        Re: FTP a file(s) using MS Access Patrick Finucane <patrickfinucanetx@gmail.com> - 2019-09-08 12:35 -0700
          Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-08 21:03 -0700
    Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-05 10:55 -0400
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-05 13:38 -0700
        Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-05 15:49 -0400
          Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-06 10:00 -0700
            Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-08 16:05 -0400
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-12 10:47 -0700
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-12 11:16 -0700
      Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-14 12:02 -0600
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-20 17:04 -0600
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-20 17:31 -0600
      Re: FTP a file(s) using MS Access "Phil Hunt" <abc@nowhere.com> - 2019-09-23 12:37 -0400
        Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-23 17:28 -0600
          Re: FTP a file(s) using MS Access Patrick Finucane <patrickfinucanetx@gmail.com> - 2019-09-23 17:56 -0700
            Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-23 20:47 -0600
          Re: FTP a file(s) using MS Access "Phil Hunt" <abc@nowhere.com> - 2019-09-24 08:47 -0400
            Re: FTP a file(s) using MS Access Ron Weiner <rw@domain.com> - 2019-09-24 13:55 -0400
              Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-24 16:24 -0600
                Re: FTP a file(s) using MS Access Patrick Finucane <patrickfinucanetx@gmail.com> - 2019-09-25 09:57 -0700
                  Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-25 17:18 -0600
              Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-25 15:29 -0600
    Re: FTP a file(s) using MS Access PW <PW@noemailaddress.com> - 2019-09-24 15:58 -0600

Page 1 of 3  [1] 2 3  Next page →

#13766 — FTP a file(s) using MS Access

Hi,

Has anyone successfully done this?

I found a link with a download sample, nice form and docs, but it does
not work because two files that are needed to run it are not in the
zip file
(https://www.databasejournal.com/features/msaccess/article.php/3513061/Simple-FTP-Methods-from-Microsoft-Access.htm)

Thanks,

-paulw

[toc] | [next] | [standalone]

#13767

I didnt download the files, but from reading the linked article and skimming the code there....what 2 files are missing? 
It doesnt appear to need any additional files from my reading.
What errors are you getting?

[toc] | [prev] | [next] | [standalone]

#13768

On Wed, 4 Sep 2019 04:18:53 -0700 (PDT), Mal Reeve
<mal.reeve@gmail.com> wrote:

>I didnt download the files, but from reading the linked article and skimming the code there....what 2 files are missing? 
>It doesnt appear to need any additional files from my reading.
>What errors are you getting?

*---

Hi!

File does not exist for:

tblFtpFileList

"The recordsource 'tblFTPFileList' does not exist on this form or
report or is misspelled."

tblFtpfileList is the record source of the subform.

filelist.txt

"The Microsoft Access database engine could not find the object
'FileLilst'txt'...."

Someone posted about the first file but no response.
Another said he got it working but did not say how.

It does eventually run, but locks up when I press the upload button
after selecting one of the text files 'justforkicks.txt'


This form takes a very long time to generate those errors.  But maybe
there is enough code for me to make my own working one.

There is only one accdb file so everything should be in it or get
created I guess.

 There are no tables in the accdb, just forms, macros, modules.  I
will look at the code and see if they are created on the fly.

Thanks!

-pauwl

[toc] | [prev] | [next] | [standalone]

#13769

On Wed, 4 Sep 2019 04:18:53 -0700 (PDT), Mal Reeve
<mal.reeve@gmail.com> wrote:

>I didnt download the files, but from reading the linked article and skimming the code there....what 2 files are missing? 
>It doesnt appear to need any additional files from my reading.
>What errors are you getting?


*--

I also get this message when I start it up.  Clearly a flawed piece of
work.  Not sure what version of Access it is supposed to work with:


"FTP Demo has imported 'Favorites' and other groups into the converted
database.  If  you change the imported groups in Access 2007 or
greater, you will not see those changes if you open the database in an
older version of Access.  Also, if you change the imported groups by
unsing an older version of Access, you will not see those changes if
you opent the database in Access 2007 or greater."

Well, what are the "imported groups"? "Other Groups" ? What are
'Favorites'? "those groups"?  I have no idea what this message means.

I am using Access 2010.

I guess I will have to move on and search for something else.

Thanks!

-pw

[toc] | [prev] | [next] | [standalone]

#13770

On Wed, 4 Sep 2019 04:18:53 -0700 (PDT), Mal Reeve
<mal.reeve@gmail.com> wrote:

>I didnt download the files, but from reading the linked article and skimming the code there....what 2 files are missing? 
>It doesnt appear to need any additional files from my reading.
>What errors are you getting?


It is just one big error after another with this demo.  "The record
source 'select from tblftpfilelist order by filename specified on this
form or report does not exist.."

Again, no tables exist for this.

[toc] | [prev] | [next] | [standalone]

#13771

On Tue, 03 Sep 2019 21:32:40 -0700, PW <PW@noemailaddress.com> wrote:

>Hi,
>
>Has anyone successfully done this?
>
>I found a link with a download sample, nice form and docs, but it does
>not work because two files that are needed to run it are not in the
>zip file
>(https://www.databasejournal.com/features/msaccess/article.php/3513061/Simple-FTP-Methods-from-Microsoft-Access.htm)
>
>Thanks,
>
>-paulw


*---

It is for Win95/NT. That is why it uses a .scr file.  I saw both in
the comments.

I need to keep looking!

-pw

[toc] | [prev] | [next] | [standalone]

#13772

On Wednesday, September 4, 2019 at 9:13:57 PM UTC-5, PW wrote:
> On Tue, 03 Sep 2019 21:32:40 -0700, PW <PW@noemailaddress.com> wrote:
> 
> >Hi,
> >
> >Has anyone successfully done this?
> >
> >I found a link with a download sample, nice form and docs, but it does
> >not work because two files that are needed to run it are not in the
> >zip file
> >(https://www.databasejournal.com/features/msaccess/article.php/3513061/Simple-FTP-Methods-from-Microsoft-Access.htm)
> >
> >Thanks,
> >
> >-paulw
> 
> 
> *---
> 
> It is for Win95/NT. That is why it uses a .scr file.  I saw both in
> the comments.
> 
> I need to keep looking!
> 
> -pw

Did you check out the link referenced it the sample?

http://access.mvps.org/access/modules/mdl0015.htm

It includes very simple code that writes a text file (script) and FTP.EXE to execute the script. No table or forms.

[toc] | [prev] | [next] | [standalone]

#13782

On Thu, 5 Sep 2019 04:55:28 -0700 (PDT), Ron Paii <ron81pai@gmail.com>
wrote:

>On Wednesday, September 4, 2019 at 9:13:57 PM UTC-5, PW wrote:
>> On Tue, 03 Sep 2019 21:32:40 -0700, PW <PW@noemailaddress.com> wrote:
>> 
>> >Hi,
>> >
>> >Has anyone successfully done this?
>> >
>> >I found a link with a download sample, nice form and docs, but it does
>> >not work because two files that are needed to run it are not in the
>> >zip file
>> >(https://www.databasejournal.com/features/msaccess/article.php/3513061/Simple-FTP-Methods-from-Microsoft-Access.htm)
>> >
>> >Thanks,
>> >
>> >-paulw
>> 
>> 
>> *---
>> 
>> It is for Win95/NT. That is why it uses a .scr file.  I saw both in
>> the comments.
>> 
>> I need to keep looking!
>> 
>> -pw
>
>Did you check out the link referenced it the sample?
>
>http://access.mvps.org/access/modules/mdl0015.htm
>
>It includes very simple code that writes a text file (script) and FTP.EXE to execute the script. No table or forms.

Hi Ron,

I put the only code that was not commented out behind a button and it
did not look like it did anything:


Dim stSysDir As String
    stSysDir = Environ$("COMSPEC")
    stSysDir = Left$(stSysDir, Len(stSysDir) - Len(Dir(stSysDir)))
    Call Shell(stSysDir & "ftp.exe -s:" & stSCRFile, vbNormalFocus)
End Sub

-paul

[toc] | [prev] | [next] | [standalone]

#13787

On Friday, September 6, 2019 at 11:07:52 AM UTC-5, PW wrote:
> On Thu, 5 Sep 2019 04:55:28 -0700 (PDT), Ron Paii <ron81pai@gmail.com>
> wrote:
> 
> >On Wednesday, September 4, 2019 at 9:13:57 PM UTC-5, PW wrote:
> >> On Tue, 03 Sep 2019 21:32:40 -0700, PW <PW@noemailaddress.com> wrote:
> >> 
> >> >Hi,
> >> >
> >> >Has anyone successfully done this?
> >> >
> >> >I found a link with a download sample, nice form and docs, but it does
> >> >not work because two files that are needed to run it are not in the
> >> >zip file
> >> >(https://www.databasejournal.com/features/msaccess/article.php/3513061/Simple-FTP-Methods-from-Microsoft-Access.htm)
> >> >
> >> >Thanks,
> >> >
> >> >-paulw
> >> 
> >> 
> >> *---
> >> 
> >> It is for Win95/NT. That is why it uses a .scr file.  I saw both in
> >> the comments.
> >> 
> >> I need to keep looking!
> >> 
> >> -pw
> >
> >Did you check out the link referenced it the sample?
> >
> >http://access.mvps.org/access/modules/mdl0015.htm
> >
> >It includes very simple code that writes a text file (script) and FTP.EXE to execute the script. No table or forms.
> 
> Hi Ron,
> 
> I put the only code that was not commented out behind a button and it
> did not look like it did anything:
> 
> 
> Dim stSysDir As String
>     stSysDir = Environ$("COMSPEC")
>     stSysDir = Left$(stSysDir, Len(stSysDir) - Len(Dir(stSysDir)))
>     Call Shell(stSysDir & "ftp.exe -s:" & stSCRFile, vbNormalFocus)
> End Sub
> 
> -paul

The commented out code writes the FTP script that Shelling to FTP.exe will execute. You will need to edit it with your FTP server information and create the script file. 

[toc] | [prev] | [next] | [standalone]

#13788

>> Hi Ron,
>> 
>> I put the only code that was not commented out behind a button and it
>> did not look like it did anything:
>> 
>> 
>> Dim stSysDir As String
>>     stSysDir = Environ$("COMSPEC")
>>     stSysDir = Left$(stSysDir, Len(stSysDir) - Len(Dir(stSysDir)))
>>     Call Shell(stSysDir & "ftp.exe -s:" & stSCRFile, vbNormalFocus)
>> End Sub
>> 
>> -paul
>
>The commented out code writes the FTP script that Shelling to FTP.exe will execute. You will need to edit it with your FTP server information and create the script file. 


*---

I do not know how to create a script file!

-paulw

[toc] | [prev] | [next] | [standalone]

#13789

On Tuesday, September 10, 2019 at 12:43:32 PM UTC-5, PW wrote:
> >> Hi Ron,
> >> 
> >> I put the only code that was not commented out behind a button and it
> >> did not look like it did anything:
> >> 
> >> 
> >> Dim stSysDir As String
> >>     stSysDir = Environ$("COMSPEC")
> >>     stSysDir = Left$(stSysDir, Len(stSysDir) - Len(Dir(stSysDir)))
> >>     Call Shell(stSysDir & "ftp.exe -s:" & stSCRFile, vbNormalFocus)
> >> End Sub
> >> 
> >> -paul
> >
> >The commented out code writes the FTP script that Shelling to FTP.exe will execute. You will need to edit it with your FTP server information and create the script file. 
> 
> 
> *---
> 
> I do not know how to create a script file!
> 
> -paulw

For testing you can use any text editor. the following sample code will write the sample and return the script file name.

Function WriteFtpScript() As String
    On Error GoTo errWriteFtpScript
    
    Dim iFileNumber As Variant
    Dim ftpScriptFileName As String

    ftpScriptFileName = "c:\Temp\GetDeadLetter.scr"
    
    iFileNumber = FreeFile
    
    ' Open will fail if file exist
    Open ftpScriptFileName For Output As iFileNumber
    
    ' See: https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/ftp
    ' See: https://docs.microsoft.com/en-us/previous-versions/orphan-topics/ws.10/cc772966%28v%3dws.10%29
    ' See: https://www.c3scripts.com/tutorials/msdos/ftp.html
    
    Print #iFileNumber, "lcd c:\temp"               ' Set local directory
    Print #iFileNumber, "open ftp.someserver.com"   ' Connect to FTP Server
    Print #iFileNumber, "anonymous"                 ' User name
    Print #iFileNumber, "dash10@hotmail.com"        ' Password
    Print #iFileNumber, "cd public"                 ' FTP directory
    Print #iFileNumber, "binary"                    ' Binary Transfer
    Print #iFileNumber, "get dead.letter my.letter" ' Download Dead.Letter to c:\temp\my.letter
    Print #iFileNumber, "bye"                       ' Disconnect from FTP server
    
    Close #iFileNumber
    
    WriteFtpScript = ftpScriptFileName
    
doneWriteFtpScript:
    On Error Resume Next
    Close #iFileNumber
    Exit Function
    
errWriteFtpScript:
    Debug.Print Err.Number & ", " & Err.Description
    WriteFtpScript = False
    Resume doneWriteFtpScript
End Function

[toc] | [prev] | [next] | [standalone]

#13790

On Tue, 10 Sep 2019 12:38:47 -0700 (PDT), Ron Paii
<ron81pai@gmail.com> wrote:

>On Tuesday, September 10, 2019 at 12:43:32 PM UTC-5, PW wrote:
>> >> Hi Ron,
>> >> 
>> >> I put the only code that was not commented out behind a button and it
>> >> did not look like it did anything:
>> >> 
>> >> 
>> >> Dim stSysDir As String
>> >>     stSysDir = Environ$("COMSPEC")
>> >>     stSysDir = Left$(stSysDir, Len(stSysDir) - Len(Dir(stSysDir)))
>> >>     Call Shell(stSysDir & "ftp.exe -s:" & stSCRFile, vbNormalFocus)
>> >> End Sub
>> >> 
>> >> -paul
>> >
>> >The commented out code writes the FTP script that Shelling to FTP.exe will execute. You will need to edit it with your FTP server information and create the script file. 
>> 
>> 
>> *---
>> 
>> I do not know how to create a script file!
>> 
>> -paulw
>
>For testing you can use any text editor. the following sample code will write the sample and return the script file name.
>
>Function WriteFtpScript() As String
>    On Error GoTo errWriteFtpScript
>    
>    Dim iFileNumber As Variant
>    Dim ftpScriptFileName As String
>
>    ftpScriptFileName = "c:\Temp\GetDeadLetter.scr"
>    
>    iFileNumber = FreeFile
>    
>    ' Open will fail if file exist
>    Open ftpScriptFileName For Output As iFileNumber
>    
>    ' See: https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/ftp
>    ' See: https://docs.microsoft.com/en-us/previous-versions/orphan-topics/ws.10/cc772966%28v%3dws.10%29
>    ' See: https://www.c3scripts.com/tutorials/msdos/ftp.html
>    
>    Print #iFileNumber, "lcd c:\temp"               ' Set local directory
>    Print #iFileNumber, "open ftp.someserver.com"   ' Connect to FTP Server
>    Print #iFileNumber, "anonymous"                 ' User name
>    Print #iFileNumber, "dash10@hotmail.com"        ' Password
>    Print #iFileNumber, "cd public"                 ' FTP directory
>    Print #iFileNumber, "binary"                    ' Binary Transfer
>    Print #iFileNumber, "get dead.letter my.letter" ' Download Dead.Letter to c:\temp\my.letter
>    Print #iFileNumber, "bye"                       ' Disconnect from FTP server
>    
>    Close #iFileNumber
>    
>    WriteFtpScript = ftpScriptFileName
>    
>doneWriteFtpScript:
>    On Error Resume Next
>    Close #iFileNumber
>    Exit Function
>    
>errWriteFtpScript:
>    Debug.Print Err.Number & ", " & Err.Description
>    WriteFtpScript = False
>    Resume doneWriteFtpScript
>End Function


Still struggling to get anything to work.

But if something is using a dos command, I don't think that is going
to work with our clients that are running our application on the web
using Amazon Web Services.

Thanks,

-paulw

[toc] | [prev] | [next] | [standalone]

#13791

On Wednesday, September 11, 2019 at 4:32:36 PM UTC-5, PW wrote:
> On Tue, 10 Sep 2019 12:38:47 -0700 (PDT), Ron Paii
> <ron81pai@gmail.com> wrote:
> 
> >On Tuesday, September 10, 2019 at 12:43:32 PM UTC-5, PW wrote:
> >> >> Hi Ron,
> >> >> 
> >> >> I put the only code that was not commented out behind a button and it
> >> >> did not look like it did anything:
> >> >> 
> >> >> 
> >> >> Dim stSysDir As String
> >> >>     stSysDir = Environ$("COMSPEC")
> >> >>     stSysDir = Left$(stSysDir, Len(stSysDir) - Len(Dir(stSysDir)))
> >> >>     Call Shell(stSysDir & "ftp.exe -s:" & stSCRFile, vbNormalFocus)
> >> >> End Sub
> >> >> 
> >> >> -paul
> >> >
> >> >The commented out code writes the FTP script that Shelling to FTP.exe will execute. You will need to edit it with your FTP server information and create the script file. 
> >> 
> >> 
> >> *---
> >> 
> >> I do not know how to create a script file!
> >> 
> >> -paulw
> >
> >For testing you can use any text editor. the following sample code will write the sample and return the script file name.
> >
> >Function WriteFtpScript() As String
> >    On Error GoTo errWriteFtpScript
> >    
> >    Dim iFileNumber As Variant
> >    Dim ftpScriptFileName As String
> >
> >    ftpScriptFileName = "c:\Temp\GetDeadLetter.scr"
> >    
> >    iFileNumber = FreeFile
> >    
> >    ' Open will fail if file exist
> >    Open ftpScriptFileName For Output As iFileNumber
> >    
> >    ' See: https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/ftp
> >    ' See: https://docs.microsoft.com/en-us/previous-versions/orphan-topics/ws.10/cc772966%28v%3dws.10%29
> >    ' See: https://www.c3scripts.com/tutorials/msdos/ftp.html
> >    
> >    Print #iFileNumber, "lcd c:\temp"               ' Set local directory
> >    Print #iFileNumber, "open ftp.someserver.com"   ' Connect to FTP Server
> >    Print #iFileNumber, "anonymous"                 ' User name
> >    Print #iFileNumber, "dash10@hotmail.com"        ' Password
> >    Print #iFileNumber, "cd public"                 ' FTP directory
> >    Print #iFileNumber, "binary"                    ' Binary Transfer
> >    Print #iFileNumber, "get dead.letter my.letter" ' Download Dead.Letter to c:\temp\my.letter
> >    Print #iFileNumber, "bye"                       ' Disconnect from FTP server
> >    
> >    Close #iFileNumber
> >    
> >    WriteFtpScript = ftpScriptFileName
> >    
> >doneWriteFtpScript:
> >    On Error Resume Next
> >    Close #iFileNumber
> >    Exit Function
> >    
> >errWriteFtpScript:
> >    Debug.Print Err.Number & ", " & Err.Description
> >    WriteFtpScript = False
> >    Resume doneWriteFtpScript
> >End Function
> 
> 
> Still struggling to get anything to work.
> 
> But if something is using a dos command, I don't think that is going
> to work with our clients that are running our application on the web
> using Amazon Web Services.
> 
> Thanks,
> 
> -paulw

That's an important bit of information! All these solutions were for a Windows 7,8,10 workstation. 

[toc] | [prev] | [next] | [standalone]

#13794

>That's an important bit of information! All these solutions were for a Windows 7,8,10 workstation. 


*--

Hi Ron.

I think I have said all along that we have clients that use our
software on AWS and these solutions would most likely not work.

But except for a few things, everything works on AWS without us having
to rewrite one line of code.

However, we also have Windows desktop clients and this particular
client is one of them.

I think I have found a more simple solution for the desktop using
Windows command interface to doing it with FTP. So much more simpler
than the other solutions I have studied and experiented for many days
and hours.  I posted the link and the code from this person today here
in this thread.

However, I need to figure out how to learn how to use Explicit TTLS
instead of regular FTP (which worked for the server that we have our
website on but errors out on the clients because they require
encryption).

And a few other things that their IT guys want us to do.  So many
steps that I think probably not needed.  Has anyone heard of Curl?

I researched it and it seems to be some type of ftp program from the
90s.  Why they require us to use that also is beyond me!

Thank you so much!

-paul

[toc] | [prev] | [next] | [standalone]

#13796

On Tue, 10 Sep 2019 12:38:47 -0700 (PDT), Ron Paii
<ron81pai@gmail.com> wrote:

>On Tuesday, September 10, 2019 at 12:43:32 PM UTC-5, PW wrote:
>> >> Hi Ron,
>> >> 
>> >> I put the only code that was not commented out behind a button and it
>> >> did not look like it did anything:
>> >> 
>> >> 
>> >> Dim stSysDir As String
>> >>     stSysDir = Environ$("COMSPEC")
>> >>     stSysDir = Left$(stSysDir, Len(stSysDir) - Len(Dir(stSysDir)))
>> >>     Call Shell(stSysDir & "ftp.exe -s:" & stSCRFile, vbNormalFocus)
>> >> End Sub
>> >> 
>> >> -paul
>> >
>> >The commented out code writes the FTP script that Shelling to FTP.exe will execute. You will need to edit it with your FTP server information and create the script file. 
>> 
>> 
>> *---
>> 
>> I do not know how to create a script file!
>> 
>> -paulw
>
>For testing you can use any text editor. the following sample code will write the sample and return the script file name.
>
>Function WriteFtpScript() As String
>    On Error GoTo errWriteFtpScript
>    
>    Dim iFileNumber As Variant
>    Dim ftpScriptFileName As String
>
>    ftpScriptFileName = "c:\Temp\GetDeadLetter.scr"
>    
>    iFileNumber = FreeFile
>    
>    ' Open will fail if file exist
>    Open ftpScriptFileName For Output As iFileNumber
>    
>    ' See: https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/ftp
>    ' See: https://docs.microsoft.com/en-us/previous-versions/orphan-topics/ws.10/cc772966%28v%3dws.10%29
>    ' See: https://www.c3scripts.com/tutorials/msdos/ftp.html
>    
>    Print #iFileNumber, "lcd c:\temp"               ' Set local directory
>    Print #iFileNumber, "open ftp.someserver.com"   ' Connect to FTP Server
>    Print #iFileNumber, "anonymous"                 ' User name
>    Print #iFileNumber, "dash10@hotmail.com"        ' Password
>    Print #iFileNumber, "cd public"                 ' FTP directory
>    Print #iFileNumber, "binary"                    ' Binary Transfer
>    Print #iFileNumber, "get dead.letter my.letter" ' Download Dead.Letter to c:\temp\my.letter
>    Print #iFileNumber, "bye"                       ' Disconnect from FTP server
>    
>    Close #iFileNumber
>    
>    WriteFtpScript = ftpScriptFileName
>    
>doneWriteFtpScript:
>    On Error Resume Next
>    Close #iFileNumber
>    Exit Function
>    
>errWriteFtpScript:
>    Debug.Print Err.Number & ", " & Err.Description
>    WriteFtpScript = False
>    Resume doneWriteFtpScript
>End Function


When typing this in a cmd window:
cd c:\ftpuploadfiles 
ftp 12.123.123.123
user name
password

"ok. current restricted directory is /"

cd public_html

"current directory is public_html" (the folder where my website files
are located)

binary

"200 TYPE is now 8-bit binary"

put uploadfile.txt

"500 I won't open a connection to 192.168.... only to 192.161..."

I assumed those are my PCs IP numbers but they are not.  I turned off
my firewall but same error message

Any ideas?

-paulw

[toc] | [prev] | [next] | [standalone]

#13773

On Tuesday, September 3, 2019 at 10:31:49 PM UTC-5, PW wrote:
> Hi,
> 
> Has anyone successfully done this?
> 
> I found a link with a download sample, nice form and docs, but it does
> not work because two files that are needed to run it are not in the
> zip file
> (https://www.databasejournal.com/features/msaccess/article.php/3513061/Simple-FTP-Methods-from-Microsoft-Access.htm)
> 
> Thanks,
> 
> -paulw

FTP.exe is a command line program in Windows that you can use interactively. When you enter FTP ftp.amazecreations.com at the command line, the 14 year old site times out instead of asking for your userid and password.

Test the FTP server you are trying to connect to manually from the command line first. You'll need the name of the server, userid and password. Next, build a batch file that opens a script.  The Database Journal and MVPS links both outline this technique. Third, you can use VBA to create the batch and script files and call the batch from Access as outlined in Database Journal.

I have found WinSCP from https://winscp.net/eng/docs/guide_automation to be a more reliable and flexible FTP client than FTP.exe. With it, you can put all the commands on one line and avoid having to create the text files.

[toc] | [prev] | [next] | [standalone]

#13777

On Thu, 5 Sep 2019 06:11:17 -0700 (PDT), samxjones2@gmail.com wrote:

>On Tuesday, September 3, 2019 at 10:31:49 PM UTC-5, PW wrote:
>> Hi,
>> 
>> Has anyone successfully done this?
>> 
>> I found a link with a download sample, nice form and docs, but it does
>> not work because two files that are needed to run it are not in the
>> zip file
>> (https://www.databasejournal.com/features/msaccess/article.php/3513061/Simple-FTP-Methods-from-Microsoft-Access.htm)
>> 
>> Thanks,
>> 
>> -paulw
>
>FTP.exe is a command line program in Windows that you can use interactively. When you enter FTP ftp.amazecreations.com at the command line, the 14 year old site times out instead of asking for your userid and password.
>
>Test the FTP server you are trying to connect to manually from the command line first. You'll need the name of the server, userid and password. Next, build a batch file that opens a script.  The Database Journal and MVPS links both outline this technique. Third, you can use VBA to create the batch and script files and call the batch from Access as outlined in Database Journal.
>
>I have found WinSCP from https://winscp.net/eng/docs/guide_automation to be a more reliable and flexible FTP client than FTP.exe. With it, you can put all the commands on one line and avoid having to create the text files.


*---

Looks promising so far.  Do you know if I can do this within Access?

Also, we have some clients that use our software running on Amazon Web
Services as is.  I wonder if once I get this FTP stuff working whether
it will also work there.

Thanks!

-paulw

[toc] | [prev] | [next] | [standalone]

#13778

On Thu, 5 Sep 2019 06:11:17 -0700 (PDT), samxjones2@gmail.com wrote:

>On Tuesday, September 3, 2019 at 10:31:49 PM UTC-5, PW wrote:
>> Hi,
>> 
>> Has anyone successfully done this?
>> 
>> I found a link with a download sample, nice form and docs, but it does
>> not work because two files that are needed to run it are not in the
>> zip file
>> (https://www.databasejournal.com/features/msaccess/article.php/3513061/Simple-FTP-Methods-from-Microsoft-Access.htm)
>> 
>> Thanks,
>> 
>> -paulw
>
>FTP.exe is a command line program in Windows that you can use interactively. When you enter FTP ftp.amazecreations.com at the command line, the 14 year old site times out instead of asking for your userid and password.
>
>Test the FTP server you are trying to connect to manually from the command line first. You'll need the name of the server, userid and password. Next, build a batch file that opens a script.  The Database Journal and MVPS links both outline this technique. Third, you can use VBA to create the batch and script files and call the batch from Access as outlined in Database Journal.
>
>I have found WinSCP from https://winscp.net/eng/docs/guide_automation to be a more reliable and flexible FTP client than FTP.exe. With it, you can put all the commands on one line and avoid having to create the text files.


*--

So Sam, and others, what I am trying to do is upload a file to
someone's server where their website is.

I have created an Access form (etc...)  to export available rooms to a
.csv file.  The people that did their website have created a web form
to import a .csv file so they can display the availability dates on it
(or at least that is what they say).

So it is just updating one file for now and overwriting the old file
if one exists. I guess eventually I may want to download a file (maybe
bookings) into Access.

Thanks,

-paulw

[toc] | [prev] | [next] | [standalone]

#13783

>I have found WinSCP from https://winscp.net/eng/docs/guide_automation to be a more reliable and flexible FTP client than FTP.exe. With it, you can put all the commands on one line and avoid having to create the text files.

I installed it.  As far as I can tell so far, it is just another ftp
client like cuteftp, filezilla,....

I want to be able to ftp from within our Access 2010 application.

Thanks!

-paulw

[toc] | [prev] | [next] | [standalone]

#13784

On Friday, September 6, 2019 at 11:05:12 AM UTC-7, PW wrote:
> >I have found WinSCP from https://winscp.net/eng/docs/guide_automation to be a more reliable and flexible FTP client than FTP.exe. With it, you can put all the commands on one line and avoid having to create the text files.
> 
> I installed it.  As far as I can tell so far, it is just another ftp
> client like cuteftp, filezilla,....
> 
> I want to be able to ftp from within our Access 2010 application.
> 
> Thanks!
> 
> -paulw

Any info here help you out?
https://social.msdn.microsoft.com/Forums/office/en-US/ec4e7af6-a915-4835-bcf2-bc3a6ed377c4/ftp-vba-code-for-access-2010?forum=accessdev

[toc] | [prev] | [next] | [standalone]

Page 1 of 3  [1] 2 3  Next page →

Back to top | Article view | comp.databases.ms-access

csiph-web