By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,934 Members | 1,476 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,934 IT Pros & Developers. It's quick & easy.

copyfromrecordset does not work on different machine no errors reported

P: n/a
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,

Dec 2 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Dec 2 '05 #2

P: n/a
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?

Dec 2 '05 #3

P: n/a
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.

Dec 2 '05 #4

P: n/a
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

Dec 2 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.