CopyFromRecordset does not work on different machine

[info]

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?

[MacDermott]

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?