Unanswered: help in removing the broken reference in Access 2002
I am facing a problem in removing the missing references in Access 2002.
i am using the following code to check the broken reference.
Dim strMessage As String
Dim strTitle As String
Dim refItem As Reference
For Each refItem In References
If refItem.IsBroken Then
strMessage = "Missing Reference:" & vbCrLf & refItem.FullPath
strMessage = "Reference: " & refItem.Name & vbCrLf _
& "Location: " & refItem.FullPath & vbCrLf
In this code "refItem.FullPath" is failing for the Missing reference
to "Microsoft DAO 2.5/3.5 compatibility library"
and producing the following error.
"Run-time error '-2147319779(8002801d)"Method "Full Path" of
object 'reference' failed".
This occurs only in case of "Access 2002 on Windows XP", but in the
site they have given it for Access 2000.
can u please provide me a solution how to remove the missing reference
programmatically in Access 2002