CopyFromRecordset does nothing

[Hafeez]

I have a routine written and executed from an access
modulate that creates an instance of Excel and copies a
recordset from access to Excel using the CopyFromRecordSet
method.
Currently, this code is being executed successfully on
about 50 separate machines running windows and excel 2000.
Just recently, one of the users has reported an error and
I've isloated it the "CopyFromRecordSet" routine.
I don't know why the code stops working (no error message
is given). I've searched the KnowledgeBase but have come
up with nothing.

TIA
Hafeez

 

[Tom Ogilvy]

Possibly the user has a reference to DAO and it is at a higher level than
the reference to ADO. Not sure how that would happen and would expect it
would raise an error, but something to check.

 

[Hafeez]

The user has the exact same references set as everyone
else that's using the tool.
This thing is really confusing me!
Hafeez Esmail