Forum Discussion
Coping Access tables
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.- Is there a user group that discusses writing code for Access data bases other than this one?
