Geek asks and answers

How to get data records that have been changed in the Access database

I have an Access database with many tables and thousands of records in it, if someone changes any data in it, any row or even just a cell, is there any way to find out which particular row or cell has been changed in the Access database any property or should I use some kind of trigger?

+3
source share
1 answer

I had a similar problem a couple of years ago using MSSQL DB, and I seem to remember that both ACCESS (MDB) and SQL (MDF) DO databases do not inherit this support. You, if I am not mistaken, will have to accept the principles:

1) , , . :

  • PrecursorRecId, record_id .
  • Context_ID, , AuditTxnContext.
  • TxnDate ( )

2) , EffectiveFromDate EffectiveToDate, NULL EffectiveToDate . MaterData . , RecordCreatedDateTime, EffectiveFromDate.

, , . , , , . , . , , , .

, . , , .

Mac

+2

More articles:


All Articles