[AccessD] favor running code in 2K and XP

Susan,

Is the reference listed as "MISSING" in Access 2000?  Missing references
can cause all kinds of havoc in VRA, even with methods not related to the
missing reference.

If it is missing, either install Excel and make sure the reference is set,
or delete the reference.  Then see if you are still having trouble.

HTH,

Steve

-----Susan Harkins' Original Message-----

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