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

The PasteErrors table shows in which records an error occurred.

If there were 2 errors in a table with 50,000 records, searching for those 2 errors in the table itself would take a long time. The PasteErrors table will contain only 2 rows, telling you directly which records were affected.

Answer 3

the values shown in "Paste error" table is available in the actual table. then why such table is being created.