table "Paste Errors" created


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


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.

Kind regards, HansV

6 people found this reply helpful


Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated December 29, 2020 Views 6,380 Applies to: