Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #13785
| From | Ron Weiner <rw@domain.com> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: FTP a file(s) using MS Access |
| Date | 2019-09-08 16:05 -0400 |
| Organization | WorksRite |
| Message-ID | <ql3mts$tda$1@dont-email.me> (permalink) |
| References | <3efumeh5gvsg3623o260u00uaeode4r4vo@4ax.com> <qkr7m0$eqe$1@dont-email.me> <56s2ne972ji7rn9j0rr9fc1dk2vttromj7@4ax.com> <qkrorj$r03$1@dont-email.me> <a145ne1m6o0urr4p05tigpf5kr130ki5ol@4ax.com> |
on 9/6/2019, PW supposed : > On Thu, 05 Sep 2019 15:49:05 -0400, Ron Weiner <rw@domain.com> wrote: > >> PW formulated on Thursday : >>> 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 >> >> The MDA is (was) an Access Addin DB. Try importing all of the classes >> and Modules that were in the MDA into the main ACCDB. Then re-try the >> sample code. I guess that Access no longer supports MDA's. Fact is I >> never used the MDA, I always imported the FTP Class directly into any >> Access projects that needed to have FTP capability. >> >> It was many years ago, and I seem to remember that there were some >> rough spots that needed to be worked around, but in the end I was able >> to move files hither and yon errorlessly. >> >> Rdub > > > *--- > > I imported all the modules from the converted mda file into > intettransfer sample.mdb but I still get that error when running the > test upload button on the sample form. > > I am not sure how to copy all the classes from the object browser but > they look the same to me in both accdb files. > > -paulw You are going to have to modify the code as there is no longer an InetTransferLib.ftp associated with you project. There is however a FTP class that you imported from the MDA. If the name of the class os cFTP Try: Dim objFTP As cFTP instead of Dim objFTP As InetTransferLib.FTP Later one the nthe code path there will be a statement something like: Set objFTP = New InetTransferLib.FTP You will also need to change that to something like: Set objFTP = New cFTP What you aew looking to do is not a standard Access DB "thing". Be prepared to make changes in what you were given, to get it working. Don't be afraid to try shit. What's the worst that can happen? What you have now is aparently not workng, so what the hell. :-) I assure you that the basic code you have in front of you WILL WORK, as I started using this class when I was in my 50's. I am now a retired septuagenarian, and my Access Apps that use it are still in service. Don't give up!!! Rdub
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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