Link to home
Start Free TrialLog in
Avatar of Roberts B
Roberts BFlag for United States of America

asked on

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
SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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