[AccessD] FTP to server

[Stuart McLachlan]

Google says:

When FTP Client sends it's Private IP Address to the FTP Server; FTP Server can't 
recognize this Internal IP Address and it can only recognize the Public IP of the FTP 
Client; throws a message shows "500 I won't open a connection to ...". 


Are you using a VPN?  That could  cause an issue with a mismatch between  your actual 
public IP address and your VPNed public IP address.


On 3 May 2023 at 8:27, Rocky Smolin wrote:

> Stuart (or anybody)
> 
> So I got the code working that you sent - connect to the server, ftps
> the file to the server, but the file ends up with zero bytes.
> 
> When I use FTP.exe and put the commands in manually the last command -
> ftp? put "This is a test.docx" I get the response: 500 I won't open a
> connection to 100.68.156.242 (only to 136.22.14.36)
> 
> Any idea what this means and how to get around it?
> 
> TIA
> 
> Rocky
> 
> 
> On Thu, Apr 20, 2023 at 8:01PM Rocky Smolin
> <rockysmolin2 at gmail.com> wrote:
> 
> > Thank you.  I took a look at it. I'll try to make sense of it. 
> > Stand by for questions. "o)
> >
> > r
> >
> > On Thu, Apr 20, 2023 at 2:30PM Stuart McLachlan
> > <stuart at lexacorp.com.pg> wrote:
> >
> >> Sent.
> >>
> >> On 20 Apr 2023 at 9:40, Rocky Smolin wrote:
> >>
> >> > Yes, in Access. I remember but the client went away to try to do
> >> > it himself so I stored that demo and now can't retrieve it. 
> >> > Could you send again?
> >> >
> >> > Thanks
> >> >
> >> > r
> >> >
> >> > On Wed, Apr 19, 2023 at 9:43PM Stuart McLachlan
> >> > <stuart at lexacorp.com.pg> wrote:
> >> >
> >> > > In Access or do you just want to upload a file to a server?
> >> > >
> >> > > If in Access, we went through this on 31 Mar/ 1 Apr.   I sent
> >> > > you a sample database that does it on 31 March.
> >> > >
> >> > >
> >> > >
> >> > >
> >> > > On 19 Apr 2023 at 20:00, Rocky Smolin wrote:
> >> > >
> >> > > > Dear List:
> >> > > >
> >> > > > I am looking for some help FTPing a file to a server.  The
> >> > > > user has given me the Host (target server), User Name,
> >> > > > Password, and Port.  I can open a file dialog box for him to
> >> > > > point to the file to be uploaded.
> >> > > >
> >> > > > But I can't find what I'm looking for on the web that doesn't
> >> > > > use and ocx or other 3rd party tool that I don't have anyway.
> >> > > > Would like to keep it simple if possible.
> >> > > >
> >> > > > 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
> >>
> >>
> >> --
> >> 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