Copy and Paste table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tang - 17 Jan 2008 15:44 GMT

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

Reply to this Message

Klatuu - 17 Jan 2008 17:00 GMT

Explain what you mean by "copy and paste". This is not something normally
done in an Access database.

Signature

Dave Hargis, Microsoft Access MVP

> 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
[quoted text clipped - 3 lines]
>
> thanks

Reply to this Message

John W. Vinson - 17 Jan 2008 17:53 GMT

>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
[quoted text clipped - 3 lines]
>
>thanks

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]

Reply to this Message