Viewing Deleted Records can be useful

[Guest]

Giving Access the capability of viewing deleted records (similar to FoxPro)
can be very useful to the programmers.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-ad13-7a25c4a427e7&dg=microsoft.public.access

 

[Joseph Meehan]

Giving Access the capability of viewing deleted records (similar to
FoxPro) can be very useful to the programmers.

You can do it yourself. Just add a binary filed to the tables and use
that field to indicate "deleted" records. Filter out the deleted records on
your forms queries and reports. Any time you want them back, just remove
the filter. You could even add a date deleted if you like.

Remember to compact the database after you do real deletes to actually
delete the data. If you have deleted data and not run delete, it is
possible, but not easy, to recover the deleted records.

 

[Guest]

Add a field named something like Deleted, Rescinded, Active, etc. Just
change the flag when the status of the records changes. You can also add a
DateTime field to indicate when the change occured.

 

[Guest]

I wasn't looking to recover any deleted data. Just to verify some of the
values that had been in the data that was deleted. I don't have to add any
special fields in FoxPro to do this, and I had hoped that Access was the
same. When I did a search for viewing deleted data I realized that it is not
and made this suggestion. There is no reason for users to see data after it
has been deleted, but occasionally a programmer may want to verify something.
Thanks for the suggestion, but I don't see a need to change the structure of
these tables for this purpose.