Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP2010 SP3 - Run-time ...
Microsoft Dynamics GP (Archived)

GP2010 SP3 - Run-time error '429' ActiveX

(0) ShareShare
ReportReport
Posted on by Mick Egan 3,557

Running a Test upgrade from GP10 to GP2010, add a window to vba and used the connection string:

Getting the error when trying to set the connection at: Set cn = UserInfoGet.CreateADOConnection
 

Run-time error '429'

ActiveX component can't create the object.

object variable or with block variable not set

Code:

Dim userinfoObj As UserInfo
Dim CompanyName As String
Dim cn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim cmd As New ADODB.Command


Private Sub Window_BeforeOpen(OpenVisible As Boolean)
CallConnection
End Sub

Public Function CallConnection()

Set cn = UserInfoGet.CreateADOConnection
cn.DefaultDatabase = UserInfoGet.IntercompanyID
cmd.ActiveConnection = cn
cmd.CommandType = adCmdText
End Function

*This post is locked for comments

  • alvavendela Profile Picture
    alvavendela 5 on at
    RE: GP2010 SP3 - Run-time error '429' ActiveX

    Solve runtime error 429 by following given below steps:-

    Reinstall Microsoft .Net Framework

    Scan the system and check the programs code where you have written the code to create an object:-

    If you created object in your program by using "NEW" operator then remove it and use Create Object function.

    you can aso fix runtime error 429 by using third party repair tool. www.r6034runtimeerrorfix.com

  • faisal shah Profile Picture
    faisal shah 10 on at
    Re: GP2010 SP3 - Run-time error '429' ActiveX

    Hello

    If you fell problem to fix runtime error 429, I am sharing steps to fix this error.

       If any programs are open, close all of them

       Press Start, Press Run

       In Run Box type CMD and press ENTER

       A Command Prompt Window will pop up, type Regsvr32 command. For example, if OCX file name is vbalexpbar6.ocx then type regsvr32 vbalexpbar6.ocx

       Press ENTER to process the command

       You are done, close Command Prompt – type EXIT and press ENTER

       You have fixed error code 429 by applying this method.

    I took these steps from http://www.error429.com.

  • Verified answer
    Mick Egan Profile Picture
    Mick Egan 3,557 on at
    Re: GP2010 SP3 - Run-time error '429' ActiveX

    Arunprasath,

    Just by chance we re-registered the GPCONN.dll in the common files\microsoft shared\dexterity folder and the error 429 went away.

    Thanks for your reply.

    Mick

  • Mick Egan Profile Picture
    Mick Egan 3,557 on at
    Re: GP2010 SP3 - Run-time error '429' ActiveX

    Arunprasath,

    The VBA11.00 is referenced, we even tried downgrading back to GP10 and get the same issue.

    Mick

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: GP2010 SP3 - Run-time error '429' ActiveX

    Is Microsoft dynamics gp VBA 11.00 Type Library is added to reference?

  • Mick Egan Profile Picture
    Mick Egan 3,557 on at
    Re: GP2010 SP3 - Run-time error '429' ActiveX

    Is this one too hard for the gurus??

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans