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

CopyFromRecordset does not work on different machine

P: n/a
I have an Access Application which happily uses CopyFromRecordset to
transfer values from an access query via a recordset to an excel
spreadsheet, this works on three machines. However, when I try it on a
fourth machine (same versions of Excel & Access), no records are
transfered (I check that the recordset contains records which it does).

Any ideas?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Perhaps a permissions problem?
Does the user on the 4th machine have write permissions in the folder where
the Excel spreadsheet is located?
Or perhaps the XLS file itself is protected?

You might start by seeing if you can open the Excel file and write to it
manually on the 4th machine...

<in**@lowerbill.co.uk> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
I have an Access Application which happily uses CopyFromRecordset to
transfer values from an access query via a recordset to an excel
spreadsheet, this works on three machines. However, when I try it on a
fourth machine (same versions of Excel & Access), no records are
transfered (I check that the recordset contains records which it does).

Any ideas?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.