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