[AccessD] Access Check References

William Hindman wdhindman at dejpolsystems.com
Wed May 27 00:58:39 CDT 2009


Group

...I'm running the following code within a private sub in my startup form:

    Dim chkref As Reference

    For Each chkref In Application.References
        strLog = strLog & IIf(chkref.IsBroken, "## Broken Reference", "OK") 
& " ref: " & chkref.Name _
               & " " & chkref.Major & "." & chkref.Minor & " " & 
chkref.FullPath & vbNewLine
    Next

...works like a charm ...except that the log reads as follows:

OK ref: VBA 4.0 C:\Program Files\Common Files\Microsoft 
Shared\VBA\VBA6\VBE6.DLL
OK ref: Access 9.0 C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB
OK ref: DAO 5.0 C:\Progra~1\Common~1\Micros~1\dao\dao360.dll
OK ref: stdole 2.0 C:\WINDOWS\system32\stdole2.tlb
OK ref: ADODB 2.8 C:\Program Files\Common Files\System\ado\msado15.dll

...where the heck did the VBA 4.0/Access 9.0/DAO 5.0 come from?

 William
 






More information about the AccessD mailing list