Q: uploading file via FTP?

  • Thread starter Thread starter Mark Das
  • Start date Start date
M

Mark Das

(using Access 2000 on Win2000)

Is there a way to upload to an FTP site using access?

I know I can create a script file and call that script
file from Access (opening a command prompt), but the big
problem with that is I have to put the password in that
script file.

Any way to do this solely through Access, and requesting
the password through an inputbox?

Thanks!
-Mark
 
Mark Das said:
(using Access 2000 on Win2000)

Is there a way to upload to an FTP site using access?

I know I can create a script file and call that script
file from Access (opening a command prompt), but the big
problem with that is I have to put the password in that
script file.

Any way to do this solely through Access, and requesting
the password through an inputbox?

Thanks!
-Mark
Click to expand...

Try the Internet Transfer Library from

http://www.mvps.org/access/modules/mdl0037.htm

Note that although this is downloaded as an Access 97 addin, in Access
2000+ you have to import the classes from this file into your own
project to use them.
 
Hey thanks, Dirk, Dev,

I don't think I'll be able to use this add-in however. I
work for a company that requires me to notify them if I
add any component to an application, and from what I hear,
unless it comes straight from the Microsoft site, I'll be
going through hoops trying to get the permission.

I appreciate the help, though. Thanks again,
-Mark


-----Original Message-----
Dev Ashish said:
Note that although this is downloaded as an Access 97 addin, in
Access 2000+ you have to import the classes from this file into your
own project to use them.
Click to expand...

FWIW, although the page, along with the component, haven't been
updated to reflect the changes, here's a relatively complete Version
2.0 of the code as a COM dll.

[
Click to expand...
Click to expand...
http://www.mvps.org/access/downloads/InternetTransferLib.zi
p ]
 
Mark Das said:
Hey thanks, Dirk, Dev,

I don't think I'll be able to use this add-in however. I
work for a company that requires me to notify them if I
add any component to an application, and from what I hear,
unless it comes straight from the Microsoft site, I'll be
going through hoops trying to get the permission.

I appreciate the help, though. Thanks again,
Click to expand...

There's not much you can do in the face of corporate stupidity, but if
you simply import the classes from the Access 97 add-in into your
application, you'll be using plain VBA code that does nothing more than
call into the Windows API. No "black-box", third-party components.
 
Back
Top