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

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.

--
Regards,
Tom Ogilvy

"Hafeez" wrote in message
...
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

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

-----Original Message-----
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.

--
Regards,
Tom Ogilvy

"Hafeez" wrote in message
...
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


.