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?
 
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
 
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:
As I worked through a number of scenarios, which in part involved both suggestions.
0
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.