I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
(OP)
This is really embarrassing, and I'm frankly baffled at how it happened.
I was trying to create the copy of the structure of a table containing just over 4,000 records, and it instead created the structure and data, b/c I forgot to change the selection. Well, I thought no big deal, I'll just delete all the records in this copy of the table. Well, somehow, how I have no idea, it deleted on one command (manual - not vba, query, or anything like that) - all records in the original table as well as my copy.
So now I've got a file recovery request in, and won't get that until 2pm tomorrow. Is there any way I can find the now deleted records in a temp table? I already asked everyone to back out of the database.
I have some backups, but not really recent. However, I just remembered I do at least have an export in Excel that has all the data I think, so I may be in okay shape.
So, my question is - does anyone know of an easy - maybe VBA - method of recovering deleted records?
Thanks for any suggestions/thoughts. I'll have to work on a Plan B, and C in the meantime.
I was trying to create the copy of the structure of a table containing just over 4,000 records, and it instead created the structure and data, b/c I forgot to change the selection. Well, I thought no big deal, I'll just delete all the records in this copy of the table. Well, somehow, how I have no idea, it deleted on one command (manual - not vba, query, or anything like that) - all records in the original table as well as my copy.
So now I've got a file recovery request in, and won't get that until 2pm tomorrow. Is there any way I can find the now deleted records in a temp table? I already asked everyone to back out of the database.
I have some backups, but not really recent. However, I just remembered I do at least have an export in Excel that has all the data I think, so I may be in okay shape.
So, my question is - does anyone know of an easy - maybe VBA - method of recovering deleted records?
Thanks for any suggestions/thoughts. I'll have to work on a Plan B, and C in the meantime.
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
RE: I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
RE: I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
RE: I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
RE: I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
RE: I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
RE: I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
RE: I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
Here's how it all happened:
- I was going to delete yet another record based on one of the users' suggestions. I thought you know it'd be good to have a "deleted items" table in case we later find out - oh, maybe we shouldn't have deleted that. I figured easiest way was to create a copy of the STRUCTURE of the existing table.
- I hit copy, paste, gave it a name and hit [Enter] - I forgot to change the selection from structure + data to structure only.
- After it completed, I thought, okay, I don't need ALL the records in the new table, just the ones I'm getting from a delete request. So I proceeded to select all records (in the new table - original table was open, but in the background), right-click, and selected delete all records. It said are you sure, you're about to delete x # of records which sounded correct, and I said ok.
- I then pasted one row to the newly empty table (again, just one paste - one table "active", since Access, as far as I know only allows one "actively selected" table at a time.
- I looked right after that, and noticed both tables were now empty except for the one pasted record which needed to be deleted anyway. [angry]
So, now I've learned my lesson. EVEN when the event occurred b/c of a mistake, STILL backup before doing anything like a mass deletion!!"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
RE: I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
Yep, any test code that can remotely inconvenience me if records are lost - I duplicate the table(s) first.
5 second job to create, 5 second job to remove the duplicate(s) after.
(Only becomes automatic after you've failed 10 times as above though (slow learners us coders ain't we?)).
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience.
RE: I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
True. Of course, you do realize this thread has sat before this for nearly 5 months, right? Well, maybe you didn't notice the date. I've done the same a time or two.
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
RE: I Deleted All Records in an Access Table - Hopes of Recovering from within temp tables of Database??
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57