Active X component can't create object

I have a Access 2010 32 bit database I created. When I run it on 64 bit Access I get an error "Run-time error 429 Active X component cant't create object"

    Set Host = CreateObject("BZWhll.WhllObj")
    ResultCode = Host.Connect("A")

Can anyone offer any solution for this please?

Roberts BCustoms BrokerAsked:
Who is Participating?
Bill PrewConnect With a Mentor Commented:
Check with the vendor and see if they have a 64bit version of the control, that would be my first attempt.

Dale FyeConnect With a Mentor Commented:
64 bit Office will not run most Active X controls.

Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
Just to add a bit; if 64 bit Edition of Office, then any calls made are 64 bit.

 That means:

1. Active-X controls
2. Calls to .DLLs
3. Calls to .accde's
4. WinAPI calls
5. ODBC driver calls


  Everything must support 64 bit.    Given all that, it's why Microsoft still recommends to this day that the majority of users will want the 32 bit edition.

 The only advantage to the 64 bit edition is very large spreadsheets in Excel, and large projects in Visio  and MS Project.  Outside of that, there is no feature difference.

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

It's these pesky ActiveX controls and office Addins that has Microsoft STILL recommending a 32 bit install of Office rather than a 64 bit install.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Well if Microsoft would add some value to the 64 bit platforms, then people would take the time to re-write things.

 Until that happens, no ones going to take the times to re-invent the wheel.

 64 bit is an idea well before it's time.

PatHartmanConnect With a Mentor Commented:
I'll bet that if we were to take a poll, 90% of the people who read this would have no idea what 32-bit/64-bit is all about so let me offer a simplistic explanation.

Bits in this case refer to the size of a register which is actually dictated by the PC's hardware.  Currently, there are few PCs manufactured that support less than 64-bit registers.  Most are 64-bit.  Mainframes are larger. Phones and tablets and calculators are smaller.  Registers are used in machine language (what EVERYTHING we code ultimately comes down to) to store memory addresses.  The larger the register, the larger the address space available to the application.  That means a larger monitor with more pixels or a larger hard drive or larger internal memory - anything that stores data like floppies and CDs and thumbdrives, etc.  So bigger registers allow computers to run more programs simultaneously and to use larger storage media and bigger monitors.

OK, How does that affect software?  Not very much as it turns out which is why we still use 32-bit Office on our 64-bit PCs.  The difference is in how much static data an application can reference at one time rather than what the software actually does.  64-bit Excel allows Excel to work with humongous spreadsheets.  Not many people actually need a million rows in a sheet.  64-bit Word allows Word to work with humongous documents.  Both will be slow and clunky at some point when processing huge documents.  Since Access is a relational database it works with data record by record.  it doesn't load everything into memory as Word and Excel do so unless you make huge internal arrays, you probably would never, ever benefit from 64-bit Access.  Access can make use of larger memory spaces and that will reduce paging (saving intermediate results to disk) so sorts of large recordsets could be faster if all the rows fit in memory at one time and Access doesn't have to do the sort piecemeal with a final merge.

32-bit software runs on 64-bit hardware because the hardware "masks" the unused high-order half of the register so the 32-bit software only uses half the available space to store an address.

The bottom line is that 64-bit is not inherently "better".  The software features are identical.  The speed is similar.  The difference comes down simply to do you need to process documents that are too large for 32-bit registers?  The problem is that addins must match the software it is attaching itself to bit-wise and not all addins have been reissued in 64-bit versions so for most companies, they loose more than they gain.
Dale FyeCommented:
I would take me (Dale) out of the point mix;  I didn't really contribute anything.

My recommendation would be:
Pat and Jim were the major contributors (400 each)
200 to Bill.  

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.