Run-time Error 429 ActiveX Component Cant Create Object with VBA

Article ID: 867131 - View products that this article applies to.
Expand all | Collapse all

TechKnowledge Content

Question: When trying to connect to an ODBC DataSource using RDO within VBA, an error message is returned. It worked fine on the development machine but when transferring the project to another machine the following error: Run-time error '429' ActiveX component can't create object is returned. Why doesn't it work on the 2nd machine?

Answer: This actually is a built in limitation of VBA. While VBA allows you to create references to RDO on a development machine that has VB or C++ installed, it actually doesn't allow it to distribute this solution to a customer that does not have these tools installed. If VB or Visual C++ is installed (as in the situation above), it may work on the end user's machine but this solution isn't supported by Microsoft. The link below connects to a Microsoft Technical document that discusses this problem.

This article was TechKnowledge Document ID: 9560


Article ID: 867131 - Last Review: July 14, 2012 - Revision: 3.0
Applies to
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0
  • Microsoft Great Plains eEnterprise 7.0
  • Microsoft Great Plains Dynamics 7.0
  • Great Plains eEnterprise 6.0
  • Great Plains Dynamics 6.0
  • Modifier with Visual Basic for Applications
kbmbsmigrate KB867131

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from