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


Groups > comp.databases.ms-access > #13775

Re: FTP a file(s) using MS Access

From PW <PW@noemailaddress.com>
Newsgroups comp.databases.ms-access
Subject Re: FTP a file(s) using MS Access
Message-ID <56s2ne972ji7rn9j0rr9fc1dk2vttromj7@4ax.com> (permalink)
References <3efumeh5gvsg3623o260u00uaeode4r4vo@4ax.com> <qkr7m0$eqe$1@dont-email.me>
Organization Forte - www.forteinc.com
Date 2019-09-05 13:38 -0700

Show all headers | View raw


On Thu, 05 Sep 2019 10:55:57 -0400, Ron Weiner <rw@domain.com> wrote:

>After serious thinking 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
>>
>> ---
>> This email has been checked for viruses by AVG.
>> https://www.avg.com
>
>Try this link  http://access.mvps.org/access/modules/mdl0037.htm
>
>Look for the Internet Data Transfer Library.  Download the 
>InetTransferLib.zip File.  In the Zip you will fine a file 
>"InetTransferLib.mda".  I believe that this is in an Access 97 File 
>Format, so you will have to convert it to a Access 2000 or later format 
>to open it.
>
>In any case there is a complete Access FTP class in that DB that I have 
>been using for more than 15 years in my Access projects.  The class is 
>an Access only thing that does not require any external libraries, 
>ActiveX thing-a-ma-gigs, or anything else for that matter.
>
>It was written by Dev Anish and Terry Kreft in the late 90's, so it has 
>been around for a while.  I am surprised that you haven't come across 
>it in your investigation.  Invest a little time in learning how to use 
>the class (I think there is some sample code), and you'll have a stable 
>foundation for your project.
>
>Rdub


*---

Hi,

The zip file contained:

InetTransfer sample.mdb (with a space)
InetTransferLib.mda

I converted both to .accdb (A2007 format was chosen by Access even
though I am using 2010 - I guess they are the same from what I
remember)

I got an error message running the TestFTPUpload code behind the FTP
Upload button on the sample accdb "cannot find project or library" on
the line Dim objFTP As InetTransferLib.FTP

I tried to add a reference to InetTransferLib.accdb (was .mda) and was
unable:  "Name conflicts with existing module, project, or object
library".

So, it is unusable so far.

Any ideas?

-paulw

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

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

csiph-web