Link to home
Start Free TrialLog in
Avatar of Lou Dufresne
Lou DufresneFlag for United States of America

asked on

MS Access 2003 - missing Reference

I am running a MS Access 2003 Application on windows 7, Ms Office 2010.

When it loads it indicates : Your database or project contains a missing or broken reference VB6EXT.olb version 5.3"
In the VBA Reference section it shows it checked as "Missing" but when you look for it in the reference list it is not listed there.

Where can I find and how can I load the "Missing Reference VB6EXT.olb"?
Or
If I convert the database to a Office 2010 will this fix the problem or make it worse.
 
Thansks for your assistance.
LAD
SOLUTION
Avatar of Bardobrave
Bardobrave
Flag of Spain 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
SOLUTION
Avatar of omgang
omgang
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
See this link re. Access 2010 using vb7 instead of vb6
http://www.utteraccess.com/forum/MZ-Tools-2010-t1946477.html

In the References dialogue click Browse... and navigate to the path in my prior post.  Does the path exist?  Is the .olb file there?  Is there a VBA7 directory?  I don't have Access 2010 installed so am kind of shooting in the dark here.  Hoping it helps.
OM Gang
ASKER CERTIFIED SOLUTION
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
As a side note, I can confirm that MZTools does in fact work in A2010, Win 7 x64 and A2010 Win XP.
The VBA IDE in A2007/10 is virtually identical to A2003.  In fact, any customizations you may have made in the A2003 VBA IDE ... the Reg Key that contains those can be used in A2010.

mx
Avatar of Lou Dufresne

ASKER

The best Solution for my situation was provided by LSM Consulting.

Bardobrave and omgang provided addtional knowledge indolving this problem and possibly handling this situation with other PC

Database MX alwys is there for additional support and it is appreciated.

Thank you all.

LAD