help

[CJ]

I am new to access and I think I just deleted my entire
database. If you delete items in a query and save the
changes, the changes take effect on the related table.
Can these changes be undone?

 

[Cheryl Fischer]

If a user answers 'Yes' to the prompts that appear when deleting records,
the records are gone. That is why backups are so strongly recommended.

You may wish to send a copy of your database to Peter Miller at
http://www.pksolutions.com/services.htm. He is often (for a fee) able to
work miracles.

 

[John Vinson]

I am new to access and I think I just deleted my entire
database. If you delete items in a query and save the
changes, the changes take effect on the related table.

Exactly. The query has no independent existance; it's just a way of
ordering, filtering, and displaying the data in a Table. Deleting a
record in a Query permanently and irrevokably deletes the record in
the Table (and you get a warning message that it will do so).

Can these changes be undone?

Not at home. There are third-party database salvage services which can
recover the data (for a fee) if you've been living right - Peter
Miller's service at http://www.pksolutions.com is a highly recommended
one.