ActiveX Error 429, "Can't create object"
 

In running a VBA process in Excell2000 to query an Access database, I
get this error on some machines, but not others. In perusing the
internet, I have come across various "fixes", but nothing seems specific
to Excel, mostly VB5 and VB6.
Do I need to do something on my target machines to re-register some dll
or ocx?
I can post the offending code if you want.

Thanks

Doc Rock

ActiveX Error 429, "Can't create object"
 

This article may help.

http://support.microsoft.com/default...b;en-us;200271

Alt F11, Tools|References and look for something marked as 'MISSING' also
check that an Add In isn't missing.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Doc Rock" wrote:
| In running a VBA process in Excell2000 to query an Access database, I
| get this error on some machines, but not others. In perusing the
| internet, I have come across various "fixes", but nothing seems specific
| to Excel, mostly VB5 and VB6.
| Do I need to do something on my target machines to re-register some dll
| or ocx?
| I can post the offending code if you want.
|
| Thanks
|
| Doc Rock

ActiveX Error 429, "Can't create object"
 

Thanks, I'll look at it. Does VBA in Excel 2000 equate to VB 6.0?

Dave Patrick wrote:
This article may help.

http://support.microsoft.com/default...b;en-us;200271

Alt F11, Tools|References and look for something marked as 'MISSING' also
check that an Add In isn't missing.

ActiveX Error 429, "Can't create object"
 

That's a pretty general statement but for the most part yes.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Doc Rock" wrote:
| Thanks, I'll look at it. Does VBA in Excel 2000 equate to VB 6.0?