B
boborta
Operating System: Windows 2000
Networking System Novell
Access 2000 SP-3
3 months ago converted from A97 to A2K
Several forms (source sql) we have include a button that will shift to
the datasheet view for users. In some cases, users will use the data
sheet view to copy all displayed records to the clipboard and then
paste them into Excel (2K version). This process worked without
incident until after conversion to A2K. Now we get inconstant results:
Sometimes C & P works fine
Sometimes clicking edit/copy (or Ctrl-C) causes the operation to go to
never never land - it is not unusual for Access to freeze (not
responding).
Sometimes you think the copy is done, open Excel, and attempt to paste.
However, Paste is not available in the edit/paste menu, Ctrl-V does
nothing, and (if displaying - it does not always display) the Windows
clipboard menu will not Paste. In fact, you cannot empty the Windows
Clipboard - clicking the clipboard icon (with an 'X') does
nothing. At this point, you cannot copy/paste anything to/from files
at all. You must reboot before regaining the ability to copy/paste.
I can and have written code that copies a recordset to Excel, but users
should be able to copy/past using the clipboard. Has anyone
experienced this problem with A2K or any other version?
Thanks for looking,
Bob
Networking System Novell
Access 2000 SP-3
3 months ago converted from A97 to A2K
Several forms (source sql) we have include a button that will shift to
the datasheet view for users. In some cases, users will use the data
sheet view to copy all displayed records to the clipboard and then
paste them into Excel (2K version). This process worked without
incident until after conversion to A2K. Now we get inconstant results:
Sometimes C & P works fine
Sometimes clicking edit/copy (or Ctrl-C) causes the operation to go to
never never land - it is not unusual for Access to freeze (not
responding).
Sometimes you think the copy is done, open Excel, and attempt to paste.
However, Paste is not available in the edit/paste menu, Ctrl-V does
nothing, and (if displaying - it does not always display) the Windows
clipboard menu will not Paste. In fact, you cannot empty the Windows
Clipboard - clicking the clipboard icon (with an 'X') does
nothing. At this point, you cannot copy/paste anything to/from files
at all. You must reboot before regaining the ability to copy/paste.
I can and have written code that copies a recordset to Excel, but users
should be able to copy/past using the clipboard. Has anyone
experienced this problem with A2K or any other version?
Thanks for looking,
Bob