<div>
are both machines using the same version (SP) of DAO?<br />
<br />
I think the current SP is number 8 for DAO.<br />
<br />
<a href="http://support.microsoft.com/default.aspx?scid=kb;EN-US;829558" rel="ugc">http://support.microsoft.com/default.aspx?scid=kb;EN-US;829558</a><br />
<br />
Mike<br />

</div>


are both machines using the same version (SP) of DAO?

I think the current SP is number 8 for DAO.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;829558 [http://support.microsoft.com/default.aspx?scid=kb;EN-US;829558]

Mike


<div>
We are both using version 3.6 and have the same SP installed.
</div>


We are both using version 3.6 and have the same SP installed.

<div>
Right on, that worked! He (the other user) was running SR-1a. I upgraded to that and it works fine. Thanks!
</div>


Right on, that worked! He (the other user) was running SR-1a. I upgraded to that and it works fine. Thanks!

<div>
<div class="content wysiwyg-content">
My end goal is to transfer the data from a subform in Access 2000 to Excel 2000 via the CopyFromRecordset method. I am currently populating a DAO recordset from the subform's recordsetclone method. I then open a new Excel document through code and use the copyfromrecordset method to move the data. Most of the time it works fine on all user's machines, but when one field in the subform gets too large, some machines kick out an error of &quot;Method CopyFromRecordset of object Range Failed&quot;. The current record that is causing the problem (on my machine) is a memo field and has a length of 1187 chracters. When I run it on another developers machine, goes through fine. Any ideas on the problem?
</div>
</div>


My end goal is to transfer the data from a subform in Access 2000 to Excel 2000 via the CopyFromRecordset method. I am currently populating a DAO recordset from the subform's recordsetclone method. I then open a new Excel document through code and use the copyfromrecordset method to move the data. Most of the time it works fine on all user's machines, but when one field in the subform gets too large, some machines kick out an error of "Method CopyFromRecordset of object Range Failed". The current record that is causing the problem (on my machine) is a memo field and has a length of 1187 chracters. When I run it on another developers machine, goes through fine. Any ideas on the problem?

Access 2000/Excel 2000 CopyFromRecordset Error

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.