Lost data in Access 2002

[Guest]

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.

 

[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.

Sorry... but it's gone.

John W. Vinson[MVP]

 

[Andrew Gabb]

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?

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

 

[Guest]

Sigh. Thanks.

Roberta

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

 

[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