[AccessD] favor running code in 2K and XP

Gustav Brock gustav at cactus.dk
Fri Jun 25 09:32:30 CDT 2004


Hi Susan

What's the cure for this bug, if any?

/gustav


> Turns out it's a well known bug -- but I'll check this out too -- can't
> hurt. 

> Susan H. 

> 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