Forum Discussion
Coping Access tables
I was trying to distribute my data into multiple named tables within Access. I made a copy of the table and renamed it. Then in the copied table I remove the data I did not need in the copied table. When I went back to the original table my data was gone. What happened?
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.
If you have a OneDrive or DropBox, can you put the zipped file there and send me a link via email?
GHepworth at gpcdata dot com
- here is where if put the file:
\\DESKTOP-04SG9EU\Users\philt\OneDrive
I'm not sure if this is what you want. It is in the email attachment folder.
Phil- Unfortunately, that location is on your desktop (to which I can't connect, of course).
I was hoping you'd have a public OneDrive you can share. Let me think about this a little. There has to be a plan that will work.
We didn't see the process, so this is mostly an informed guess.
One possibility could be that you created copies of the STRUCTURE of the table, but didn't include the data when you made the copies.
Either that or you THOUGHT you were deleting data from one of the copied tables, but were actually deleting the data from the original.
Or a third possibility is that in copying tables and changing their names, you got the renaming out of synch.
There are probably other possibilities, but those three come to mind first.
Go get your most recent back up, the one you made just before starting this copy process. Create another test accdb and repeat the process of making copies, but carefully noting each table's name and the data in it before doing any deleting.
George_Hepworth I wish what you said is correct, but I made differently named copies. Went I went to the backup copies they were changed as well. Iam not sure what is going on. I have done this before several times and never had a problem.
- Unfortunately, because we didn't witness or participate in the process, all we can do is offer suggestions of things for you to consider.
Ultimately, it's the backups which bail us out when things go wrong.
