Lost data in Access 2002

R

Roberta

I just started using Access 2002 and I seemed to have erased my table and
can't access my data anymore. I was in Report Design Wizard and I clicked
delete where it said Table1. Is there any way I can get my data back?

Thanks.
 
J

John Vinson

I just started using Access 2002 and I seemed to have erased my table and
can't access my data anymore. I was in Report Design Wizard and I clicked
delete where it said Table1. Is there any way I can get my data back?

Thanks.
Click to expand...

Sorry... but it's gone.

John W. Vinson[MVP]
 
A

Andrew Gabb

Roberta said:
I just started using Access 2002 and I seemed to have erased my table and
can't access my data anymore. I was in Report Design Wizard and I clicked
delete where it said Table1. Is there any way I can get my data back?
Click to expand...

You need to restore it from a backup saved before you deleted it.
DB's don't generally have much of an 'undo' and it's fairly obvious
why in a multi-user environment.

What this means is that if you're making lots of changes, it's a
good idea to back up frequently. When I'm fiddling I usually back up
each half hour or so.

Andrew
 
R

Roberta

Sigh. Thanks.

Roberta

Andrew Gabb said:
You need to restore it from a backup saved before you deleted it.
DB's don't generally have much of an 'undo' and it's fairly obvious
why in a multi-user environment.

What this means is that if you're making lots of changes, it's a
good idea to back up frequently. When I'm fiddling I usually back up
each half hour or so.

Andrew
Click to expand...
 
A

aaron.kempf

Roberta

this is why you shouldn't ever use MDB for anything important.

ADP is the same price; but you can do real backups and restores and it
WORKS BEAUTIFULLY
 
Top