Update History

[Bumbala]

Hello,

Is there an update history in MS Access database, so that i can
retrieve information about inserted, deleted or updated records? In
other words any way to read the transaction log.

Thank you.

 

[Allen Browne]

No. JET (the database engine in Access) does not give you transaction logs.

If all entries are made through a form, you can simulate it with the events
of the form. Details in:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html