Per record metadata (Access)

[Quasar6]

(C# pro 2008, Access *.mdb file & an OleDb Connection)

Hello.

As part of a 2 database synchronisation program, I need to be able to detect the most recent/important changes.

~ Is it possible to retrieve the most recent date a record was modified via dot net? Does this data even exist? It would be invaluble when working out which records to replace/overwrite, if it does.
~ If yes, is there any other metadata I can retrieve?

Also, is there a better way to synchronise two databases? I have a few specific requirements for this program (two seperately created records with the same GUID string should be considered as the same record, and be merged, for example), which is why I've not looked to heavily into pre-built synchronisation systems, like that in Access. If anyone's used them, I'd welcome your input.

Thanks all!
Qu.

[leinad31]

In lieu of centralized tracking of changes or history table/repository, you should implement audit columns in your table design, at the very least 4; updated by, last_update (date), created by, create date.