William Hindman
wdhindman at dejpolsystems.com
Wed May 27 21:20:55 CDT 2009
...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 >