Forum Discussion
Coping Access tables
Well, at least part of the mystery might be exposed. This is an mdb with NO tables in it. It only has links to tables in a different mdb. Specifically, it points to "D:\VS2019\Horses_be.mdb" as the location of the linked files (I only checked a few; I assume they are all trying to link to that mdb.)
That means you probably did not copy the ORIGINAL table at all. What you seem to have done is copy the LINK that points always to the same source table in the "Horses_be.mdb". And that, in turn, means when you deleted records from one of the copies, you were actually deleting records from that single, source table in the other mdb.
That's my guess now, based on what I see here.
If you can get a copy of the ORIGINAL "Horses_be.mdb" we can explore further, though.