C
chip.gorman
Several people in our company have only recently begun to have a
problem with cutting and pasting to Access from Excel. It's
intermittent and we can't isolate a specific instance of what causes
the crash. It started maybe 6-8 weeks ago, however, and I suspect that
a MS update introduced some problem.
We're on Win XP, Office 2003, build 11.8146.8132. I search the MS site
but could not find this error documented.
The behavior is as follows:
- Copy a range of data in Excel.
- Switch to Access database that's already open
- Ctrl-V to paste the info.
- Access asks if the first row contains headers, click on Yes.
- Excel immediately closes all windows and provides no message
whatsoever.
Sometimes rebooting solves the issue immediately, but usually not.
However, later the programs may perform perfectly normally, even
without a reboot. We mainly use the cut-and-paste approach to get
small amounts of data over to Access (data categorizations, for
example.) But large amounts or not, we have never had this kind of
problem before.
Any ideas welcomed.
problem with cutting and pasting to Access from Excel. It's
intermittent and we can't isolate a specific instance of what causes
the crash. It started maybe 6-8 weeks ago, however, and I suspect that
a MS update introduced some problem.
We're on Win XP, Office 2003, build 11.8146.8132. I search the MS site
but could not find this error documented.
The behavior is as follows:
- Copy a range of data in Excel.
- Switch to Access database that's already open
- Ctrl-V to paste the info.
- Access asks if the first row contains headers, click on Yes.
- Excel immediately closes all windows and provides no message
whatsoever.
Sometimes rebooting solves the issue immediately, but usually not.
However, later the programs may perform perfectly normally, even
without a reboot. We mainly use the cut-and-paste approach to get
small amounts of data over to Access (data categorizations, for
example.) But large amounts or not, we have never had this kind of
problem before.
Any ideas welcomed.