restore deleted access records

[Guest]

I deleted some records from a query. Obviously I gave no attention to the
message that the records could not be recovered if deleted. This resulted in
deletion of the relevant record from the parent table. Could some one help me
retrieve those records. Both the table and querry are not deleted but I have
closed the data base.
Thanks

 

[John Vinson]

I deleted some records from a query. Obviously I gave no attention to the
message that the records could not be recovered if deleted. This resulted in
deletion of the relevant record from the parent table. Could some one help me
retrieve those records. Both the table and querry are not deleted but I have
closed the data base.
Thanks

Sorry... but deleted is GONE. The warning is meant seriously. You can
- sometimes - type Ctrl-Z *immediately* after a deletion to recover
data; and there are third-party services who can (again, sometimes)
recover data from databases. Check the links at
http://www.granite.ab.ca/access to find them (and bring your
checkbook).

As you've learned to your cost, a Query has no independent existance;
it's just a way to selectively look at data which resides in a Table.
Deleting or editing a record in a Query deletes or edits the record in
the Table; the data doesn't exist anywhere other than in the Table.

John W. Vinson[MVP]

 

[Marshall Barton]

I deleted some records from a query. Obviously I gave no attention to the
message that the records could not be recovered if deleted. This resulted in
deletion of the relevant record from the parent table. Could some one help me
retrieve those records. Both the table and querry are not deleted but I have
closed the data base.

In addition to John's response, you can use the
Relationships window (Tools menu) to specify that
referential integrity should be enforced between
parent/child tables. If you do not specify Cascade Deletes,
you will not be able to delete a parent record that has
related child records. This is a potent safety mechanism
that should be used where ever appropriate.