ActiveX component can't create object

Posted on 2011-04-27
Last Modified: 2012-05-11
I am using MS Access 2007 VBA to call a .NET DLL that has been made visible to COM and properly registered and strongly signed.  I followed the example givin at

I created the .DLL using Visual Studio 2010

I've made the reference in the VBA code AND VBA intellisense picks up the reference just fine for my class.  I've attached the code that I am using, which is a direct paste from the website above.

Upon running the code I get
Run-time error '429':
ActiveX component can't create object

offending line of code is...
Set objCalc = New SimpleCalc.Calc

After MUCH searching I've narrowed down to what seems to be a Windows 7 64bit type of issue.

I am in fact running Windows 7 64 bit.  Can anybody get this example working (from the website above) using Windows 7 64 bit, Visual Studio 2010 and Access 2007?

Am I out of luck?

Private Sub Command0_Click()
    Call test
End Sub

Public Function test()
    Dim lngResult As Long
    Dim objCalc As SimpleCalc.Calc
    Set objCalc = New SimpleCalc.Calc
    objCalc.SetNumberOne (3)
    objCalc.SetNumberTwo (6)
    lngResult = objCalc.Add()
End Function

Open in new window

Question by:dr_linux
    LVL 74

    Expert Comment

    by:käµfm³d 👽
    Did you use the 64-bit version of regsvr to register?
    LVL 6

    Author Comment

    Yes, did that, same issue.
    LVL 74

    Expert Comment

    by:käµfm³d 👽
    I'm not within reach of my 64-bit Win 7 machine, but I will have access later tonight. If you haven't received an answer by then, I'll do some investigation  = )
    LVL 6

    Accepted Solution

    Actually I found what I've been meaning to do all along, and that is to make an Add-In.  Don't know why I didn't realize that sooner.
    LVL 6

    Author Closing Comment

    Found the better solution that works, called an Access Add-In.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now