Link to home
Start Free TrialLog in
Avatar of pete feyerherd
pete feyerherdFlag for United States of America

asked on

ms access 2007 automation error excel 20116 interface not registered

ms access 2007 automation error excel 20116 interface not registered
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Do you have installed side by side Office 2007 and Office 2016...probably you have something hardcoded ...you need to use late binding.
Avatar of pete feyerherd

ASKER

Hi,
Yes, a version 2007 of access and 2016 version of excel is installed. Opened the accdb version and checked references, no missing references were found.
Maybe there are no missing references but references that shouldn't  be there...
Can you give us a screenshot of your references
along with the method that produces the error.
Also check this article on Early Binding/Late Binding....if you are using Early Binding switch to Late ....and the problem should be resolved
Hi,
The customer has upgrade msAccess to the same version as the Office version and the problem has been resolved without having to update the msAccess application.
Thanks for your input.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.