[AccessD] Access Check References

Max

...its the major and minor that are throwing me for a loop ...name and path 
appear ok ...I even tried deleting the dao reference, compiling, closing, 
opening, resetting it, and then compiling once more ...no change ...wtfo?

...first time I've tried to check references and log them when starting 
...did not expect this result ...didn't need it either.


William

--------------------------------------------------
From: "Max Wanadoo" <max.wanadoo at gmail.com>
Sent: Wednesday, May 27, 2009 2:41 AM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Access Check References

> Hello my friend, William.
>
> I would put a break point in.  Goto Immediate Window and type in each part
> of the properties you reference to see which property returns which value.
>
> ? Chkref.name
> ? Chkref.major
> ? Chkref.minor
> ? Chkref.fullpath
>
>
> Max
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: 27 May 2009 06:59
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Access Check References
>
> 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
>