Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1916
  • Last Modified:

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
0
Lou Dufresne
Asked:
Lou Dufresne
3 Solutions
 
BardobraveCommented:
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
 
omgangCommented:
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
 
omgangCommented:
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
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now