Transfering a file

  • Thread starter Thread starter belmontpine-acces
  • Start date Start date
B

belmontpine-acces

I have created a text file for orders that are written and
these need to be transferred to an ftp site.

Is there anyway I can transfer the orderfile whne I clcik
a button, the user will already be logged into the ftp site
so all I need os the code to grab the file and upload it


Thanks
 
Access does not do FTP natively.
But that doesn't mean you can't code it.

1. See http://www.mvps.org/access/modules/mdl0015.htm
2. See http://www.mvps.org/access/modules/mdl0037.htm

There is an ActiveX control that came with VB6 that works great too.
Much easier than coding your own.
I think it was called Inet.

For an upload you could write code like this:

With Inet1
.URL = txtURLbox
.UserName = txtUID
.Password = txtPWD
.Execute , "PUT " & txtLocalPath & " " & txtServerPath
End With
 
You have to have a copy of the ActiveX control.
(It does not come with Access - maybe in VB6 or other places.)

Then just drop it on the form and name it Inet1 and use the code example I
showed.
 
Back
Top