Go Premium for a chance to win a PS4. Enter to Win

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

Access 2002 missing reference {known} bug - Knowledgebase #287413

QUESTION:
Is there someplace I can refer to that will list the Access VBA References along with all the {DLLs}, {TLBs}, etc. associated with the reference?

BACKGROUND:
I have just upgraded one of my customers to OfficeXP from Office2000.
Everything works OK except the users occasionally get the following error message:

"... missing or broken reference to the file OWC10.dll version 1.1"

However, when I look at the VBA references, there are no {MISSING} references.

Microsoft acknowledges the problem/bug in Knowledgebase Article 287413 and tells you how to fix it, provided
you can translate the error message {i.e., OWC10.DLL} to the appropriate reference.  Since there is not a {MISSING}
to mark the problem reference, I have no idea what reference OWC10.DLL refers to.

Thanks,
Slator
0
Slator
Asked:
Slator
1 Solution
 
rockiroadsCommented:
   Dim loRef As Access.Reference
    Dim intCount As Integer
    Dim intX As Integer
   
   
   
    Err.clear

    'Count the number of references in the database
    intCount = Access.References.Count
   
    For intX = intCount To 1 Step -1
       
        Set loRef = Access.References(intX)

        Debug.Print loRef.Name, loRef.FullPath

        debug.print loReg.IsBroken        
    Next
   
    Set loRef = Nothing

0
 
SlatorAuthor Commented:
Thanks for the quick response.  I will award the points.

Slator
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

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