Forum Discussion
Coping Access tables
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.
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?
- George, I did all the copying of the tables manually. I marked all the data in the tables manually. I don't know how the backup data changed at the same time I was looking and the live table. I only looked at one table at a time. All the tables in Access file are linked via the relationship arrow (I'm not sure how all of them became related, but I assume that has something to do with the problem). I do have other copies of the tables under completely different names in completely different locations and they are what they were when I copied them. Something is going on and I not sure what I need to do to fix this problem.
Again, It's impossible to guess what might have happened. Sorry, but data doesn't change in tables independently. If, perhaps you have some sort of relationships defined and enforced with Cascade Delete enabled, that could cause deletion of data in those child, or many side tables.
The fact that you have other copies of the accdb where this problem didn't appear is reassuring, though. Whatever you did in this one is apparently a one-off. Please understand, without a first hand look at the process you went through (which is, of course, impossible) or at the accdb itself, it's guesswork.
Therefore, if you can share a copy of this accdb, someone might be able to identify some potential reasons for the problem.You will find other sites like UtterAccess and Microsoft Answers, as well as others. A little bingoogling will find them.
George_Hepworth I'd be glad to share, but the data base is 250,000+records. Which is why I wanted to split the data into separate tables. I do not have (that I know of) any of the apps you mention. A zipped copy of the data is 35 Mb. Let me know how to proceed.
- Is there a user group that discusses writing code for Access data bases other than this one?