Q: uploading file via FTP?

[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

 

[Dirk Goldgar]

(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

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.

 

[Dev Ashish]

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.

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.

[ http://www.mvps.org/access/downloads/InternetTransferLib.zip ]

-- Dev

 

[Dirk Goldgar]

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.

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.

[ http://www.mvps.org/access/downloads/InternetTransferLib.zip ]

Cool! Thanks, Dev.

 

[Mark Das]

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-----

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.

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.

[

http://www.mvps.org/access/downloads/InternetTransferLib.zi
p ]

 

[Dirk Goldgar]

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,

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.