Link to home
Start Free TrialLog in
Avatar of zimmer9
zimmer9Flag for United States of America

asked on

How to resolve 'Your Microsoft Access database or project contains a missing or broken reference to the file 'excelloaderctrl.dll' version 1.0.' from an Access 2010 application?

How to resolve the following error:

I am using Windows7 and Microsoft Access 2010.

When I open a Microsoft Access 2010 application (mdb type file), I get the following error:

Your Microsoft Access database or project contains a missing or broken reference to the file 'excelloaderctrl.dll' version 1.0.

----------------

In the applicaiton REFERENCES, I have the following 2 checked:

Microsoft Excel 11.0 Object Library
ExcelloaderCtrl 1.0 Type Library
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

try,
unchecking  Microsoft Excel 11.0 Object Library then click OK
go back and look for Microsoft Excel 11.0 Object Library and check
then click OK

this will refresh the connection to the libraries

do a debug>compile
correct any errors raised.
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
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