Stuart McLachlan
stuart at lexacorp.com.pg
Thu May 28 00:27:49 CDT 2009
And in 2007 it shows as DAO 12.0 :-( On 27 May 2009 at 22:20, William Hindman wrote: > ...uh, nice punt but I don't think so :) > > ...this is dao3.61 in Ak23 ...the dao for A2k7 is named something like > daoadc iirc > > William > > -------------------------------------------------- > From: "Charlotte Foust" <cfoust at infostatsystems.com> > Sent: Wednesday, May 27, 2009 2:26 PM > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Subject: Re: [AccessD] Access Check References > > > 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 > > > > -- > > 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