?
Solved

Unable to load Internet Transfer Control  in Access 2002

Posted on 2005-04-28
7
Medium Priority
?
323 Views
Last Modified: 2012-05-05
I need to FTP files from my local server to a remote site. I have read, on this site and throughout the web, that I need to use Internet Transfer Control  Active X objects in order to achieve this. I searched the list on objects found in Tools -> References and the closest thing I can find is Microsoft Internet controls.
 
I attempted to load the Microsoft Internet controls but inet remained unrecognized. How do I load Internet Transfer Control in access 2002; Or what do I need to do to FTP if this is not possible?
0
Comment
Question by:rufassa
  • 4
5 Comments
 
LVL 36

Accepted Solution

by:
SidFishes earned 500 total points
ID: 13890539
ITC is MSINET.OCX (you will likely have to browse for it)...however... ITC is only licensed if you have VB Studio or maybe Access With Developer extensions...

0
 
LVL 36

Expert Comment

by:SidFishes
ID: 13890565
you might find a solution here

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

haven't used it (i use itc) but those guys know their stuff..
0
 

Author Comment

by:rufassa
ID: 13902227
The add-in this site provides is for Access 97 and it will not allow me to add this to later versions of Access. Can you give me a step by step description of how i can load ITC to access.
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 13946544
open a window in code view

go to tools > references >browse for MSINET.OCX in system32 click on it click ok and it will be available in the More Controls icon in your toolbox

however as I said...
 ITC is only licensed if you have VB Studio or maybe Access With Developer extensions...

If you don't have either, you will get a You Don't have a License error

0
 
LVL 36

Expert Comment

by:SidFishes
ID: 13946557
and btw...

you CAN use the code for versions higher than 97

"To use this functionality in Microsoft Access 2000 or higher, please import all the classes from the addin (which does not have the tables required for a typical Access addin) in your own Access project. To use the classes, just refer to them with the 'InetTransferLib.' prefix (eg: Dim objHTTP As HTTP)"  - http://www.mvps.org/access/modules/mdl0037.htm

0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

840 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