table "Paste Errors" created

Question

Hi!

I've got a DB with Access (2000 format) but I am currently using a MS Access 2010 version. My concern is, the other day I realized that the DB has a local table called 'Paste Errors'. I've never created such table in my DB, but it was automatically created, so I dont know which is the function of this table, I opened it and it shows only numbers...Therefore I want to know whether this table is needed or not, and why it appeared without any command..

Thanks in advance

Sebas

Answer 1

When you copy some data and paste them into a table in Access, some of the data might fail to be pasted because they don't have the correct size or format for the destination.

If that happens, Access will create a table named Paste Errors that contains details of the records that failed. Immediately after pasting, it can be worthwhile to see if such a table has been created, and if so to use it to find out what caused the problem.

After that, you can safely delete the Paste Errors table without adverse effects.

Answer 2

Yes, the Paste Errors table should list the row numbers of the records in which a problem occurred.

Answer 3

Can we utilize the paste errors table to show the users the specific records that had issues getting pasted?

Please don't piggyback your question on someone else's thread, especially a 5 yr old thread. Use the participate link above to start your own thread.

Answer 4

Can we utilize the paste errors table to show the users the specific records that had issues getting pasted?

Answer 5

Thanks, it was helpful :)