Reference Libraries

[shannonp]

How can one "ensure" that a database has all applicable libraries available? I've noticed that some installs of Access (2000 or greater) do not include libraries that I've referenced when designing my database.

Is it a matter of informing users that they have to install the latest service packs etc...? Or, as with most programming languages where you're able to refence DLL's can I do something similar in Access?

Any advice here would be appreciated.


Shann

 

[PHV]

As a starting point:
Function ReferenceInfo()
Dim strMessage As String
Dim strTitle As String
Dim refItem As Reference
On Error Resume Next
For Each refItem In References
If refItem.IsBroken Then
strMessage = "Missing Reference:" & vbCrLf & refItem.FullPath
Else
strMessage = "Reference: " & refItem.Name & vbCrLf _
& "Location: " & refItem.FullPath
End If
Debug.Print strMessage
Next refItem
End Function

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[shannonp]

Thanks PH, I just tried your code which identifies what libraries are available (or not). In the case of a missing library what would my next step be?: to inform the user they need to install missing libraries? If so, I actually don't know how to do this (have always assumed service packs/updates would do it for me) so it would be ignorant of me to ask my users to do this until I knew what I was talking about.

A little more background, the file I am distributing is an mde file which is locked down so they have no access to the database window and only customized toolbars are available. Is this going to pose a problem in terms of trying reference a library that isn't actually installed? I'm think


Shann