Problem making making reference to a DLL in Access2K DB!

[jimtmelb1]

Hi,
I'm sorry but I have been unclear in a previous post so I am trying again.

I have an Access 2000 database. All my users have Microsoft Access 2000 runtime or Microsoft Access the full program. Both these packages when installed install the MS09.dll (Microsoft Office Object Library).

In my next update of my database I had to make reference to this dll. So I will be sending the updated Access frontend to my users. On the updated database on my computer I referenced MS09.dll from the Access 2000 runtime path. (Majority of clients will be using the runtime)
If any clients have the runtime installed to the default path they will be okay to run successfully. If any users have the full Access or have installed the runtime to a different path they will have a problem.

Can anyone tell me what I should do so that I can find this reference on the computer when they run the update for the first time. If anyone can show me how this is done I will be very gratefull

Thanks again for all your help.
Jim

 

[PHV]

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