• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 787
  • Last Modified:

FTP from VBA using Windows 2k8 Server R2

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.
0
dennisdh86
Asked:
dennisdh86
  • 3
1 Solution
 
dennisdh86Author Commented:
i did try using this before - couldn't get it to work, not sure why.
0
 
jmoss111Commented:
Ive been using a solution based on http://www.mvps.org/access/modules/mdl0037.htm for quite awhile. If you download files larger than 42 mb you will run into a numeric overflow error 6 in a counter.
0
 
dennisdh86Author Commented:
i have tried this solution as well, but found it poorly documented and therefore rather cumbersome to implement. It does work right now; however I was drawn to msinet.ocx because of the StateChanged event and its ability to tell me what point i'm at. (Also there is plenty of documentation for it.)

Do you know if there is a way this can be accomplished using the solution above?
0
 
dennisdh86Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now