Charlotte Foust
cfoust at infostatsystems.com
Wed May 27 13:26:29 CDT 2009
DAO 5.0 would be the latest and greatest I would think. It was stuck on an earlier version for several releases of Access before they decided to bump it up in 2007, right? Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman Sent: Wednesday, May 27, 2009 11:20 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Check References ...well ok ...say the Access version is 11 but the Access Object Library version is 9.0 ...implying that MS did not always change the object library with each new version of Access ...I'm just guessing of course but I could live with that. ...but the DAO bit really bugs me ...DAO 5.0????? ...where the heck did THAT come from? ...someone, somewhere knows the answer ...maybe one day I will as well ...but probably not today ...like jc said ...its "Access" :( William -------------------------------------------------- From: "Stuart McLachlan" <stuart at lexacorp.com.pg> Sent: Wednesday, May 27, 2009 8:36 AM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Access Check References > I found that page earlier when I was trying o find an answer. > > It does not say they are the right version Numbers, it just says that > that is what is displayed. > They are clearly NOT the right version numbers. > > If it is Microsoft Access 11.0 Object Library, why does it show Access > 9.0? > > > > On 27 May 2009 at 8:09, William Hindman wrote: > >> ..ok ...it looks like those ARE the right major/minor numbers after >> all ...why, I've not a clue :( >> >> http://msmvps.com/blogs/access/archive/2008/02/24/fetching-the-refere >> nce-description.aspx >> >> ...if one of you gurus care to shed some light on this it would be >> much appreciated >> >> William >> >> -------------------------------------------------- >> From: "William Hindman" <wdhindman at dejpolsystems.com> >> Sent: Wednesday, May 27, 2009 7:29 AM >> To: "Access Developers discussion and problem solving" >> <accessd at databaseadvisors.com> >> Subject: Re: [AccessD] Access Check References >> >> > ...I'm heading off to get some sleep but I 'thimk" that I have to >> > somehow ask it for the max version, not the base which I think is >> > what we're seeing ...but then again I need sleep badly ...when I >> > was 25 I could work 72 hrs w/o a nap and still be effective ...at >> > 62 my body rebels after less than >> > 24 >> > w/o some sleep ...and its just plain old shutting down as I type :( >> > >> > William >> > >> > -------------------------------------------------- >> > From: "Stuart McLachlan" <stuart at lexacorp.com.pg> >> > Sent: Wednesday, May 27, 2009 6:49 AM >> > To: "Access Developers discussion and problem solving" >> > <accessd at databaseadvisors.com> >> > Subject: Re: [AccessD] Access Check References >> > >> >> Good question! >> >> >> >> I get the same strange version numbers and you are correct, they >> >> are not the right Versions according to everything I can find. >> >> I've no idea where they come from and I can't find anything on the >> >> web to explain it. >> >> >> >> WTF? MS DLL Hell strikes again? >> >> >> >> >> >> On 27 May 2009 at 5:30, William Hindman wrote: >> >> >> >>> ...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? >> >>> >> >> >> >> >> -- >> >> 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 >> > >> >> >> -- >> 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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com