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
LVL 1
Lou DufresneIT Business Analyst CSM / Project ManagerAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
VB6EXT is a file used for addins. I can't imagine you'd need that as a Reference, if that's what you're referring to. I'd try this:

1) Make a copy of your database
2) From the VBA Editor, click Debug - Compile. Fix any errors. Continue doing this until the menuitem is disabled.
3) Click Tools - References and uncheck the VB6EXT reference.
4) Now Debug - Compile again.

If you receive no further errors in Step #4, there is a 99.999999999% certainty that you don't need that reference checked.
0
 
BardobraveConnect With a Mentor Commented:
Maybe this is a distributable object and you must provide it to your cilent machines when installing application?

Check on a computer where application works fine if the file VB6EXT.olb exists, and copy it to a machine where you get the error (to the same path).
0
 
omgangConnect With a Mentor IT ManagerCommented:
On a Win7 Pro machine running Office 2007 the file should be located at
C:\Program Files\Common Files\microsoft shared\VBA\VBA6
It is part of the Office install.  When you installed office did you do a complete/full install?  Perhaps you can go through the add/install components wizard of your Office 2010 and make sure all of the Access and shared components are installed.
OM Gang
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
omgangIT ManagerCommented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
Lou DufresneIT Business Analyst CSM / Project ManagerAuthor Commented:
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
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.