Access 2002 VB Module controlling Excel 2002 spreadsheet -Run-time
 

Usage:
€¢ ActiveSheet.Paste Link:=True or ActiveSheet.Paste ,True
€¢ Access 2002 VB Module controlling Excel 2002 spreadsheet
€¢ Used 6 different times per record, up to 24 records per recordset, up
to 40 recordsets
€¢ Works fine on local machine
€¢ Fails when using Remote Desktop Connection with:

Run-time Error €˜1004:
Microsoft Excel cannot paste the data.

€¢ Consistent failure on this statement
€¢ Inconsistent failure as to which instance/record/records it fails on €“
if fails at all (fails more times than not)