FTP from VBA using Windows 2k8 Server R2
Posted on 2010-08-23
I am creating a Microsoft Access database that needs to send and receive files via FTP.
I'm running Windows Server 2008 and MS Office 2003. So far everything has been fine.
I downloaded msinet.ocx. I placed it in the System32 file; but when I tried to reference it from within VBA, it couldn't find the file. Puzzled, I placed the file in c:/. Then I referenced it. Also registered it from that location. However, when I attempted to register it from the System32 file, I got the message "the module may not be compatible with the version of Windows you're using."
Anyway, when I try to run the VBA code, I get the following message: "ActiveX Component can't create object."
Also, this is being used completely in memory - its not tied to a control of any sort on a form. Does it need to be?
Any ideas ?? I read a bunch of things online ranging from licensing issues to 64-bit incompatibility . . . i'm lost.