copyfromrecordset does not work on different machine no errors reported

[Allthumbs]

Hi,
Both laptops seem to have the same set up office 2002 and windows XP.
But copyfromrecordset works fine on one PC and fails in another. It
does not throw any exception. Help!! thanks,

[Jana]

G'morning~

You may want to check the references for the database on the good
machine and compare them to the references on the bad one. You can
find the references by viewing a code module, then clicking Tools, then
References in the pull-down menu. Recordset functions usually require
ADO or DAO libraries loaded.

HTH,
Jana

[Lyle Fairfield]

TTBOMK CopyFromRecordSet is an MS Web Application method, and not a
meber of either Access, VBA, ADO or DAO. I've never seen it used in
Access. Can it be used; is it used; is there an example?

[Allthumbs]

Hi Jana,

Thanks! I checked the references and they are identical . I also
checked the dates on the dll files to make sure I did not have a
different version.

[RoyVidar]

Lyle Fairfield wrote in message
<11**********************@g43g2000cwa.googlegroups .com> :

TTBOMK CopyFromRecordSet is an MS Web Application method, and not a
meber of either Access, VBA, ADO or DAO. I've never seen it used in
Access. Can it be used; is it used; is there an example?

You are correct. It is also a method of Excel's Range object, and works
with both ADO and DAO recordsets when automating.

--
Roy-Vidar