[AccessD] favor running code in 2K and XP

Susan Harkins ssharkins at bellsouth.net
Thu Jun 24 13:52:58 CDT 2004


An editor's having trouble with the Remove method in 2K and XP. I was able
to re-create it by running an Access 2003 db with a reference to Excel 2003
on a system with Access 2000 and no Excel. The error says the object doesn't
suppor the method -- and points to the Remove method, but it's there in
Intellisense. 
 
It's only 2000 and 2k -- any ideas? 
 
Susan H. 
 
 
Sub RemoveBrokenReferences()
  'Find and remove broken references
  Dim ref As Reference
  For Each ref In Application.References
      If ref.IsBroken = True Then
        Application.References.Remove ref
      End If
    Next
End Sub




More information about the AccessD mailing list