Update History

  • Thread starter Thread starter Bumbala
  • Start date Start date
B

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change History (Log) 1
History 2
query to show all differences between two records? 1
Access Updating inventory levels 0
comment history in Access2007 3
Crating a Macro or button to move record 4
Record-Locking remains open after closing 0
Update or Append Query 16

Back
Top