William Hindman
wdhindman at dejpolsystems.com
Wed May 27 04:30:34 CDT 2009
...duh ...good question ..."I" think its as follows: VBA 4.0 ...should be VBA 6.0 Access 9.0 ...should be access 11.0 DAO 5.0 ...should be DAO 3.6 ...but maybe NOT ...I've never actually looked at the references this way before. ...so tell me, what is correct and where can I find any "reference" to those reference numbers, eh ...I'm more than a bit confused, apparently a result of getting old ...or so I'm told by the kids. William -------------------------------------------------- From: "Stuart McLachlan" <stuart at lexacorp.com.pg> Sent: Wednesday, May 27, 2009 3:29 AM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Access Check References > 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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >