Solved

FTP from VBA using Windows 2k8 Server R2

Posted on 2010-08-23
5
738 Views
Last Modified: 2013-11-29
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
Comment
Question by:dennisdh86
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 12

Expert Comment

by:mcv22
ID: 33505188
0
 

Author Comment

by:dennisdh86
ID: 33505326
i did try using this before - couldn't get it to work, not sure why.
0
 
LVL 18

Accepted Solution

by:
jmoss111 earned 300 total points
ID: 33506045
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
 

Author Comment

by:dennisdh86
ID: 33513658
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
 

Author Closing Comment

by:dennisdh86
ID: 33745584
Thanks!
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question