[AccessD] FTP to a web site

[Rocky Smolin]

Thanks. I'm looking at the code he's using and there's no port
specification in it. SO not sure what to do about that. Not my strong suit.

r

On Fri, Mar 31, 2023 at 12:16 PM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

> So there are three ways to do this in Access:
>
> 1. Construct a batch file, and then use Shell() to call it.  Personally, I
> like this approach as it gives you the flexibility to use the FTP client
> you
> want, and it's testable/debugable (you can type the commands manually on a
> command line, execute the batch file, etc).  Only down side is you need an
> FTP client that can handle command line arguments.
>
> 2. You can FTP using functions in the inet transfer lib in Windows.
> There's code on the MVP site for this.  It's ancient, but still works last
> I
> checked.
>
> 3. You can buy a commercial active-x control.
>
> <<. It stopped working and he says his IT people say it needs to have a
> port.>>
>
>  It does indeed.   As a test, IT should drop the firewall(s) for a few
> minutes and then see if the code works.  Traditionally, FTP uses port 21
> and
> 20, and is based strictly on TCP.   If anything is blocking those, FTP
> won't
> work.   If they don't want to drop the firewall, then you can test with an
> FTP client, or TELNET.
>
>  Sounds like configuration problems rather than finding a way to do FTP
> differently.
>
> Jim.
>
>
> -----Original Message-----
> From: AccessD On Behalf Of Rocky Smolin
> Sent: Thursday, March 30, 2023 7:18 PM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>; Off Topic <dba-ot at databaseadvisors.com>
> Subject: [AccessD] FTP to a web site
>
> Deal List(s):
>
> I have a legacy client who needs to FTP a document to a website from an
> Access front end - to a specific URL I assume.
>
> Is there a simple way to do this with VBA? Is there a more complicated but
> hopefully canned piece of code he could insert as a Public sub or function
> and call it whenever he needs to send the doc?
>
> I can send the code he's using now. It stopped working and he says his IT
> people say it needs to have a port. I don't know if that's the case.  But
> the code he's been using for 16 years suddenly doesn't.
>
> MTIA
>
> Rocky
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>