Using VB AxtiveX controls (.ocx and .dll files) in VBA

[Zukkster]

I'm trying to FTP data from and Access database using the iNet control.

This uses the Microsoft Internet Transfer Control (msinet.ocx). This is a VB control and not an Access control. I have VB on my PC, so I can reference it fine and it works.

The trouble is when someone who doesn't have VB6 on their PC tries to use the database I get the dreaded

Error 429 activex component can't create object

as soon as they try to reference the iNet control.

If I install the ActiveX section of VB on their PC the problem goes away. Is this the only way to get around the problem or am I missing something?

I've tried copying the msinet.ocx msinet.deg and comcat.dll file from my PC to the other user and running regserv32 but the problem persists.

Surely I don't have to install the ActiveX components of VB on all users PC.

I've trawled the internet and found plenty of people with the same issue and nobody with the solution.

Stars for the answer. It's driving me bonkers

 

[oharab]

Surely I don't have to install the ActiveX components of VB on all users PC.

Yes you do! I think it's something to do with dependencies
However, do not dispair, have a look at

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

which exposes http and ftp objects for you to manipulate without having to use that nasty control!
If you are using A2k or above you need to import all the objects into your database and get rid of the 'InetTransferLib.' bit in the code.
I've just had a quick play and it works pretty well.

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------