Delete Records

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi,

Your feedback would be much appreciated. I am looking for the table that delete record in the main table and store delete records in different table for trace. Sometime, I am little afraid when I delete by accident or delete the records, the records are gone. I might want to restore one record back to the main table.

Will this possible? If yes, please provide some information on coding.

Thank
 
This is not a simple thing to do, but if you always delete through a form,
you can use the events of the form to create an audit trail.

Details in article:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi,

Your feedback would be much appreciated. I am looking for the table that
delete record in the main table and store delete records in different table
for trace. Sometime, I am little afraid when I delete by accident or
delete the records, the records are gone. I might want to restore one
record back to the main table.

Will this possible? If yes, please provide some information on coding.

Thank
 
Bill

Sometimes folks mean different things by the same word.

In addition to Allen's approach, you might also consider simply adding a
Yes/No field to your table (Deleted?). You could then filter your forms and
reports through a query that excludes the "deleted" records. The same
approach can be used to avoid "moving" rows to an Archive table -- leave
them in place and "mark" them as archived.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top