Thanks for the response.
In further investigations this difficulty only reared it's ugly head after
I've transferred some data into an empty database from an old Foxpro
program. And, I noticed further that the file, when transferred, had some
controls that didn't tranfer due to an incompatibility with the way the
controls were set up in the Access file. If I tried to copy the first record
to a new record right away, I'd get this problem sometimes (probably only
when the first record was one of these "null in the control" records). But,
I also have a little utility that makes sure the controls have the right
kind of data in them after this transfer process and if not, forces it to be
a 1 or a -1 or whatever is needed. After running this utility, I don't have
the problem of losing the copy/paste ability.
So, it would seem that the problem crops up when the record I'm trying to
copy isn't set up the way it should be (no nulls, or whatever) and so Access
weirds out and won't let me copy/paste anything from then on.
Again, don't know if it's a problem with Access or what, but at least I've
figured out how to get around it and not lose the ability to copy/paste.
Thanks again,
ron
"missinglinq via AccessMonster.com" <u28780@uwewrote in message
news:75e4d8e4b172b@uwe...
I've seen posts on this from time to time and the consensus has always
been
that, as you've surmised, it's not an "Access deal" but rather a systems
resources problem. When this happens, other posters have even tried
opening
Word or Excel and tried to copy & paste with identical results. The fact
that
rebooting solves the problem just support's the assumption that the
problem
is one of system resources. Access can be a real resources hog at time!
--
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200707/1