ActiveX problem in MS Access 2010

Using MS Access 2010
I have several form within the database that use the TreeView object
The error (attached imaged) appears every time I use one of the forms containing the TreeView
Even after getting the error I can use the TreeView to see the data provided, error shows every time I expand or shrink items in the TreeView object

I have checked the preferences in VB code to see if any are missing - those selected are all available (see preferences image).

Background: The same database has been working (no errors) for past 5-6 years on other PCs - The issue has arisen when I copied the database on to another PC - All PCs have the same OS etc (Win 7 Pro 32bit, MSO 2010).
ActiveX error in MS Access 2010 form - needing help in fixing.
Capture.PNG
Capture2.PNG
LVL 1
AIGSNetwork AdministratorAsked:
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.

Gustav BrockCIOCommented:
You have two versions - 5 and 6 - loaded as a Reference. That is doomed to fail.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
In addition to Gustav's comment - are you sure that control library is properly installed on the target machine? It's not marked as MISSING, which means it's there, but it could be corrupt or have some other sort of failure. I'm not sure where you'd get a fresh copy of that library (it's pretty old), but perhaps you could locate the original install source and try that.

Note too that the Treeview control (and all the others in that library) are no longer in active development. That's a recipe for disaster if your application is critical to your business.

Also be aware that as Access moves on, you'll find less and less compatibility with ActiveX controls. While the Treeview is generally more compatible than most, it's not designed for use with Access, and Access has no obligation to ensure that future versions of Access will be compatible. If you must have the Treeview, you might consider switching over to this one:

http://www.jkp-ads.com/Articles/treeview.asp
0
AIGSNetwork AdministratorAuthor Commented:
Thanks to you both.

In the end I was able to replace the original ActiveX .OCX files (along with registering them) and it now works fine. So I am assuming one of them was either an incorrect version or was corrupted.

Thanks again.
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
AIGSNetwork AdministratorAuthor Commented:
As I worked through a number of scenarios, which in part involved both suggestions.
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
ActiveX

From novice to tech pro — start learning today.