Does MS Access update the data on the clipboard from a query when the data in the database changes?
Posted
by
leeand00
on Super User
See other posts from Super User
or by leeand00
Published on 2012-09-25T18:35:47Z
Indexed on
2012/09/25
21:40 UTC
Read the original article
Hit count: 206
I was just debugging a macro in MS Access, and when it hit the breakpoint ran a query and I copied the data from it to the clipboard. Some of the values were null before stepping to the next step, then I ran the next step which ran a query which changed the data I had on the clipboard. I then pasted the data and the values that were null before had been changed by the query...leading to a rather large WTF on my part when I pasted the data.
So my question is, does MSAccess update the data on the clipboard when it changes in the database? That's the only explanation I have for what occurred there.
© Super User or respective owner