Copy and Paste table

  • Thread starter Thread starter Tang via AccessMonster.com
  • Start date Start date
T

Tang via AccessMonster.com

I wonder if anyone can help me with this. I have a table which has a form
attached to input data. I've just found out that I can't copy and paste this
table because I get a message saying "Record is deleted". But I am sure there
are no records were deleted. Do I have a corrupted table? If it is, how do I
repare it

thanks
 
Explain what you mean by "copy and paste". This is not something normally
done in an Access database.
 
I wonder if anyone can help me with this. I have a table which has a form
attached to input data. I've just found out that I can't copy and paste this
table because I get a message saying "Record is deleted". But I am sure there
are no records were deleted. Do I have a corrupted table? If it is, how do I
repare it

thanks
Click to expand...

Well, copy and paste is almost NEVER an appropriate way to move data from one
place to another in Access; Append queries are much better. What are you
trying to move, and where are you trying to move it to? If you're storing the
same data redundantly in two different tables you should really reconsider
your design, it's a Bad Thing To Do.

Try Tools... Database Utilities... Compact and Repair (I think it's behind the
Office button in 2007). Usually the "record is deleted" message arises when
the data is external to Access, in SQL/Server or some other database; is that
the case here?

John W. Vinson [MVP]
 
Back
Top