[AccessD] Access Check References

Stuart McLachlan stuart at lexacorp.com.pg
Wed May 27 02:29:28 CDT 2009


Looks to me like:

Name   Major Minor  FullPath
VBA        4       0       C:\Program Files\Common Files\Microsoft 
                                       Shared\VBA\VBA6\VBE6.DLL
Access     9      0      C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB
DAO         5      0      C:\Progra~1\Common~1\Micros~1\dao\dao360.dll
etc.

What's the problem?


On 27 May 2009 at 1:58, William Hindman wrote:

> 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
>  
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





More information about the AccessD mailing list