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
Roberts BCustoms BrokerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
64 bit Office will not run most Active X controls.

Dale
0
Bill PrewCommented:
Check with the vendor and see if they have a 64bit version of the control, that would be my first attempt.


»bp
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)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

 etc.

  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.

Jim.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

PatHartmanCommented:
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.
0
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.

Jim.
0
PatHartmanCommented:
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.
1
Dale FyeOwner, Developing Solutions LLCCommented:
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.  

Dale
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.