Having an active Remote Desktop connection to a Windows Server 2003 or Windows XP Pro machine stops the Clipboard working in MS Access 2002 on the local machine (not the remote desktop).
The clipboard view states 'Item not Collected' everytime CTRL+C or using shortcuts for copy are clicked when try to copy data from a cell or row in an MS Access table.
As soon as the remote desktop connection is terminated the Clipboard starts working again. A reboot of the PC initially cures the problem but within a hour or so of use the problem returns.
The problem existed with the earlier version of Remote Desktop Client and the latest version (6.0). I have tried it with the Remote Desktop local resource clipboard enabled and disabled. This has no effect.
Word and Excel seem to be unaffected by this problem