copyfromrecordset does not work on different machine no errors reported

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allthumbs - 02 Dec 2005 14:50 GMT

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,

Reply to this Message

Jana - 02 Dec 2005 15:16 GMT

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

Reply to this Message

Lyle Fairfield - 02 Dec 2005 15:27 GMT

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?

Reply to this Message

RoyVidar - 02 Dec 2005 19:21 GMT

Lyle Fairfield wrote in message
<1133537236.079610.153630@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.

Signature

Roy-Vidar

Reply to this Message

Allthumbs - 02 Dec 2005 15:28 GMT

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.

Reply to this Message