[AccessD] FTP to a web site

[Stuart McLachlan]

FTP uses Port 21 by default. That's what any standard FTP server will be listening on and 
what FTP.exe connects.  There's no need to specify the port. 

On 31 Mar 2023 at 16:52, Rocky Smolin wrote:

> 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:16PM 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
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com