Delete Records

[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

 

[Allen Browne]

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

 

[Jeff Boyce]

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>