Cannot create ActiveX Component

[Tyke]

I have a VBA routine which runs on all of our machines, except one

 

On this machine I get two error messages when I try to run the routine.

 

1. "Licensing information for this component not found. You do not have sufficient rights with this license to use this functionality in the development environment."

 

2. "Cannot create ActiveX component"

 

What is also strange is that I can run the module when I log on with Administrator Rights.

[Tyke]

Perhaps it was an extremely large hammer used to crack a very small nut, but I have corrected the problem.

 

The number of *.ocx files that were to be found on various computers varied widely and it was not apparent which one was missing and was causing the problem. But it was apparent that those computers which had Microsoft Visual Basic installed had around twice as many ocx files ( and registered) than those without.

 

So I installed the free MS Visual Basic 2010 Express on the offending computer and the problem is solved. In the process the problem computer now has more than two and a half times as many ocx files as it had before.