I have a database that is used for a retail store, and there are a ton of items in this database that are not sold anymore. So i am trying to compare this table to the sales invoices and pick out barcode numbers that don't appear in the invoice from the last say 5 or so months. I figured out how to do all of that, but i decided that i can't just delete these items i will have to store them so that they can be looked at later and then deleted. I chose to just use an access file so that i could copy it to a disk and bring it to different locations etc. The original Database is an sql server Microsoft to be precise.
And to just cut to the chase i keep getting this error
An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll
Additional information: This row already belongs to another table.
on this line of code(which is the set of items i am choosing to place in the access database(aka to be deleted))