Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / October 2007

Tip: Looking for answers? Try searching our database.

determine if reference library exists

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Daniel - 06 Oct 2007 14:59 GMT
Is there a way to determine if a reference library is installed on the
current computer?  I can't seem to find the proper collection for this type
of query.

Thank you,

Daniel P
Douglas J. Steele - 06 Oct 2007 19:24 GMT
Are you asking how to determine all of the reference libraries installed on
a given machine, or whether a referenced library actually exists?

For the former, you'd have to query the registry (and it's a non-trivial
exercise)

For the latter, you can check whether any of the Reference elements in the
References collection have their IsBroken property set. From the Help file:

Sub ReferenceProperties()
Dim ref As Reference

' Enumerate through References collection.
For Each ref In References
 ' Check IsBroken property.
 If ref.IsBroken = False Then
  Debug.Print "Name: ", ref.Name
  Debug.Print "FullPath: ", ref.FullPath
  Debug.Print "Version: ", ref.Major & "." & ref.Minor
 Else
  Debug.Print "GUIDs of broken references:"
  Debug.Print ref.GUID
 EndIf
Next ref

End Sub

(Note that if the IsBroken property is True, Access generates an error if
you try to read the Name or FullPath properties.)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Is there a way to determine if a reference library is installed on the
> current computer?  I can't seem to find the proper collection for this
[quoted text clipped - 4 lines]
>
> Daniel P
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.