[AccessD] favor running code in 2K and XP

Gustav Brock gustav at cactus.dk
Fri Jun 25 09:04:10 CDT 2004


Hi Susan

I have not an Access 2000 installation right on hand.
Similar code works here with the minor difference that Access is
preceding "everywhere":

  Dim ref As Access.Reference
  ..
  Access.Application.References

/gustav


> 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